[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Exporting results to Excel (ViP Specific) ====
=== At 19 MAR 1998 08:38:04PM E. Franklin wrote: ===
 
{{tag>"ViP Specific"}}
 
<QUOTE>
Can the results of a query in a data object be exported to an Excel

spreadsheet?



My client wants a lot of columns (21) in his report, and they don't fit the reports very well, so he wants to know if there is a way to export to a Microsoft Excel spreadsheet.



Will it "create" the spreadsheet on the fly, or should an Excel boilerplate already be in place?  



If you can give me the method, and perhaps a sample of script, I would 

appreciate it.



Thanks.
</QUOTE>
----

=== At 19 MAR 1998 10:08PM John Averell Revelation wrote:  ===

<QUOTE>Microsoft distributes an ODBC driver for Excel spreadsheets (*.xls).

You should be able to install this from any Office package.

Just make an ODBC connected data object to an Excel spreadsheet.

You can then open a row in the Excel object, copy the column values from a row into it, and ExecuteUpdate(, row-by-row.

(This is what DX does, so that would be a simpler way if it does what you want.)

</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=D5446DA0B32570CC852565CD00037C37|View this thread on the  forum...]]