Page 1 of 1
Excel database
Posted: Sat Jun 09, 2012 4:57 am
by Tam123
Can anyone tell me how to/the code to import data from a excel spreadsheet into a text box created in a livecode page? I need it to select a particular sheet within that spreadsheet too not just the spreadsheet itself
Re: Excel database
Posted: Sun Jun 10, 2012 8:46 am
by Mark
Hi,
Instead of
re-posting the same text, you can also just post a reply to your own earlier post. That's called a "bump" and is sufficient to get more attention.
What you want is possible, but you might have more success asking in an Office-specific forum. You might want to create a macro that selects the columns and rows you need and use Visual Basic or VBScript to copy it to run the macro and copy the result to the clipboard. Once it is on the clipboard, LiveCode can take it from there.
Kind regards,
Mark