Page 2 of 2
Re: Pop up's in the Browser Widget
Posted: Fri Mar 30, 2018 1:30 am
by Klaus
FourthWorld wrote: ↑Thu Mar 29, 2018 6:20 pm
Excel 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.
Aha, and again I learned something new, thank you, Richard!
Re: Pop up's in the Browser Widget
Posted: Fri Mar 30, 2018 4:18 am
by FourthWorld
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.
Re: Pop up's in the Browser Widget
Posted: Wed Apr 11, 2018 8:49 pm
by gavin.funderburg
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.