Excel database

[Tam123]

Can anyone tell me how/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

[Tam123]

huh?

[Steve Denney]

Hi, look, this is a tough one. Excel is 3rd party application (microsoft). You need visual basic / visual studio or another microsoft app.
You might be able to use odbc, establish a connection and use SQL commands to import excel data.
You can certainly do that with ms access. Never tried it with excel, you'd need to set up excel as an odbc data source (windows control panel) if it's even possible.
Or you could export the data form excel 1st as a text or csv file and get it in that way. Livecode has no problem opening and reading text files.
Best of luck

[wilstrand]

Hi Tam123!

I have just released rGrid which is a spread sheet inspired grid control.
rGrid is open source so you can use the code as you wish for non commercial projects.
rGrid has an import.xlsx function built in using Curry Kenworthys spreadLib.
If rGrid could be part of a soultion for you and for me, in this stage of development, I could have some feedback
would be very valuable! There is a dictonary and a collection of demo scripts that I hope shows what can be
done and how to do it.
You can download the latest version from http://www.tapirsoft.com

With my best regards

Mats Wilstrand

[Tam123]

great thanks so much for that will check it out!!

[Adrien Bron]

Thanks so much!