Excel database

Deploying to Windows? Utilizing VB Script execution? This is the place to ask Windows-specific questions.

Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller

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

Excel database

Post by Tam123 » Fri May 25, 2012 10:55 am

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
Posts: 19
Joined: Mon Apr 30, 2007 12:55 pm

Re: Excel database

Post by Tam123 » Mon Jan 21, 2013 1:31 am

huh?

Steve Denney
Posts: 101
Joined: Wed Dec 22, 2010 8:17 pm

Re: Excel database

Post by Steve Denney » Sun Feb 03, 2013 5:31 am

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
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 114
Joined: Mon Jan 03, 2011 3:02 pm
Contact:

Re: Excel database

Post by wilstrand » Sun Mar 24, 2013 1:39 am

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
http:www.tapirsoft.on-rev.com
Open Source LiveCode Plugins - rIDE, rGrid, rTree
LiveCode projects

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

Re: Excel database

Post by Tam123 » Mon Mar 25, 2013 1:08 pm

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

Adrien Bron
Posts: 5
Joined: Tue Oct 08, 2013 2:26 pm
Contact:

Re: Excel database

Post by Adrien Bron » Tue Oct 08, 2013 4:17 pm

Thanks so much! :D

Post Reply