RE: [DUG]: Export to Excel

[Stephen Barker]

CSV (or Tab-separated) is good, but don't forget to strip out embedded commas from fields or use AnsiQuotedStr() on those fields.   Alternatively, move the data to a dBase file either using TTable (BDE), or even one of the non-BDE freeware DBF components.   Steve -----Original Message----- From: Steve Aish [mailto:[EMAIL PROTECTED]] Sent: Thursday, 25 October 2001 15:36 To: Multiple recipients of list delphi Subject: RE: [DUG]: Export to Excel 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