Aha, and again I learned something new, thank you, Richard!FourthWorld wrote: ↑Thu Mar 29, 2018 6:20 pmExcel files are Zip archives. Change the file extension to .zip, open it up, and poke around. Once you have the lay of the land you can use the revZip external to automate extraction for reformatting and presentation.
Pop up's in the Browser Widget
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Re: Pop up's in the Browser Widget
-
- VIP Livecode Opensource Backer
- Posts: 9842
- Joined: Sat Apr 08, 2006 7:05 am
- Location: Los Angeles
- Contact:
Re: Pop up's in the Browser Widget
It's kinda fun. The data is in [document]//xl/worksheets/sheet1.xml
LC's XML external should make short work of pulling out what you need.
LC's XML external should make short work of pulling out what you need.
Richard Gaskin
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
LiveCode development, training, and consulting services: Fourth World Systems
LiveCode Group on Facebook
LiveCode Group on LinkedIn
-
- Posts: 7
- Joined: Tue Mar 27, 2018 4:33 pm
Re: Pop up's in the Browser Widget
Thank you all for your help. Using BINFILE was exactly what I needed. I wrote a little VBScript to automatically convert the xls to csv and then load it up in the Livecode program. I appreciate yall's insight and knowledge, boss man was very pleased with the final product.