Re: [DUG]: Export to Excel

[Bevan Edwards]

Hi Mark,   We use a component called XLSReadWrite from http://www.axolot.com/components/index.htm, which basically does what you need, I think.  You can read and write Excel files without even requiring Excel on the user's machine!   There are a few gotcha's, such as you can't open an existing Excel file and add to it, at least not as far as I have been able to tell, and you get an exception if the file is already open, and you have to prepare the formats and sheets and stuff before the file is opened, but I generally just use it for dumping/exporting data from db apps. Regards,   Bevan   --- Bevan Edwards    mailto:[EMAIL PROTECTED] Achieve Software Limited  http://www.achieve.co.nz Phone: (64-9) 444-4210   ICQ: 732011 Fax: (64-9) 444-4201 Mobile: (64-21) 979-603     ----- Original Message ----- From: Mark Howard To: Multiple recipients of list delphi Sent: Thursday, October 25, 2001 1:45 PM 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