Can REV create Excel files?

Sadhunathan Nadesan sadhu at castandcrew.com
Fri Mar 2 13:55:20 EST 2007


Context:

Windows XP.  Microsoft Office environment.

I'm creating a desktop REV app for customer self service.

The customer needs info currently housed in a database (to which they
have no direct access) in MS Excel format on an on going basis.  Right now
this has to be done manually for them each time, and then emailed.

The app will have the necessary parameters (start date, end date,
etc.) including a file name to create.  It will hit the database (oh yeah,
I've tried to use the Rev ODBC drivers to no avail) using an http "post"
over the net to a CGI that will in turn run SQL queries, return the output
to the app, and the app will write the local file on the users machine.

Problem:

This file will be "text" (fixed column width) which then has to be
"imported" into Excel.  That works fine but it's extra steps for the
user to go through the import process and set the column markers to do
the imports (there are a lot of columns!).

Solution:

Anyone know of a plugin or feature in REV that will let us write out
.xls files directly?




More information about the use-livecode mailing list