Excel database

Creating desktop or client-server database solutions?

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

Post Reply
Tam123
Posts: 19
Joined: Mon Apr 30, 2007 12:55 pm

Excel database

Post by Tam123 » Sat Jun 09, 2012 4:57 am

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

Mark
Livecode Opensource Backer
Livecode Opensource Backer
Posts: 5150
Joined: Thu Feb 23, 2006 9:24 pm
Contact:

Re: Excel database

Post by Mark » Sun Jun 10, 2012 8:46 am

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
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

Post Reply