Using excel with Runtime Revolution

djayc2104 · Post by **djayc2104** » Sun Apr 20, 2008 11:01 pm

First of all I would just like to say that Revolution is a great piece of Software.
I need a bit of help regards a new application I have designed. It stores data into a database and what I would like to know is:
Can I export my data to excel using a command or commands in Revolution to produce reports?
As a newbie to revolution, I dont just want to buy and download an add-on but with a bit of guidance I would like to design and learn by doing it myself.

Mark · Post by **Mark** » Mon Apr 21, 2008 8:37 am

Dear djayc2104,

You can write data to a text field and import this file into Excel. The quickest way:

Code: Select all

put fld x into url "file:/Macintosh HD/Documents/file.txt"

On a PC this would look similar to:

Code: Select all

put fld x into url "file:C:/Documents and Settings/My Documents/file.txt"

Best,

Mark

Janschenkel · Post by **Janschenkel** » Mon Apr 21, 2008 12:30 pm

While exporting to tab-delimited or CSV formatted text is easy, there are other ways:
- Office 2003 and higher support an XML format (SpreadsheetML) which doesn't support macro's and all that stuff, but is great for quickly creating actual XLS files in a non-binary way.
- On a Mac, you can use AppleScript, and on Windows, VBScript, to create Excel files and fill in cells interactively. See http://www.sonsothunder.com/devres/revo ... iac001.htm for more information.
You'll want to keep a bookmark for Ken Ray's Sons of Thunder website, as it contains real gems of information.

Hope this helped,

Jan Schenkel.

djayc2104 · Post by **djayc2104** » Sun Apr 27, 2008 5:12 pm

Thank you all for your help.
Cheers