using Excel in RevStudio

LiveCode is the premier environment for creating multi-platform solutions for all major operating systems - Windows, Mac OS X, Linux, the Web, Server environments and Mobile platforms. Brand new to LiveCode? Welcome!

Moderators: Klaus, FourthWorld, heatherlaine, kevinmiller, robinmiller

Post Reply
jonesse
Posts: 2
Joined: Wed Nov 15, 2006 10:36 am
Location: London, UK
Contact:

using Excel in RevStudio

Post by jonesse » Wed Nov 15, 2006 2:12 pm

Hi, has anyone ever turned an Excel spredsheet into a compiled program using RevStusdio, please? Thanx
Jon www.frs17.com

marielle
Livecode Opensource Backer
Livecode Opensource Backer

Re: using Excel in RevStudio

Post by marielle » Wed Nov 15, 2006 4:22 pm

What is the meaning you put into Excel spreadsheet?
1. A complex table object that very much looks like an excel spreadsheet.
2. An xls file containing the excel spreadsheet?

jonesse
Posts: 2
Joined: Wed Nov 15, 2006 10:36 am
Location: London, UK
Contact:

Post by jonesse » Wed Nov 15, 2006 5:52 pm

Marielle

Thank you, I see I cannot even spell the word. I meant using an existing Excel spreadsheet with numbers and formulae and turning that into an executable with Runtime Studio. Is that clearer?
Jon www.frs17.com

marielle
Livecode Opensource Backer
Livecode Opensource Backer

Post by marielle » Wed Nov 15, 2006 6:16 pm

jonesse wrote:Using an existing Excel spreadsheet with numbers and formulae and turning that into an executable with Runtime Studio.
Yep, possible. Should be manageable for a user with good command of VBA, OS scripting languages, revolution.

From with the revolution environment, click on Documentation, enter applescript as search term. Click on the red Applescript term on the page that appears. This will connect you to a tutorial "Outstide World: Communication with Shell, Processes, Applescript of Externals".

That document explains how to communicate with other applications from within revolution.

That's a first step covered... getting access to the content of your Excel Spreadsheet from within revolution.

After that, you still have to convert your spreadsheet content to revolution. Easy for the data (cut and paste will do... you can do it via script). More difficult for the formula... the excel syntax needs to be translated into a revolution/transcript/xtalk one.

Marielle

Post Reply

Return to “Getting Started with LiveCode - Experienced Developers”