Can REV create Excel files?

[Geir A. Myrestrand]

Sadhunathan Nadesan wrote:
> 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?

It is easier to create CSV files (comma separated values), and these can 
be easily imported into Excel (or virtually any other spreadsheet).

-- 

Geir A. Myrestrand