Excel database
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
Excel database
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
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
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
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode