RE: [DUG]: Export to Excel

[Steve Aish]

The easiest way to export something that can be opened in an excel document without any formatting at all is to create a string list and write comma delimited fields and use the SaveToFile command - saving it as a CSV.   You can then open it in Excel as a CSV file.   Steve -----Original Message----- From: Mark Howard [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 October 2001 1:46 p.m. To: Multiple recipients of list delphi Subject: [DUG]: Export to Excel Hi   I have a method for opening a new Excel spreadsheet and populating it from within my app.  This leaves the spreadsheet open and the user then is responsible for saving it.   Does anyone know of a component (cheapware) that will write a dataset straight out to an Excel format file, without opening Excel.   I know there are filters you can get for QR that allow you to export a report to Excel, but I want to write the pure data without any formatting.   TIA   Mark