Exporting results to Excel (ViP Specific)
At 19 MAR 1998 08:38:04PM E. Franklin wrote:
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.
At 19 MAR 1998 10:08PM John Averell Revelation wrote:
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.)