I'd suggest trying to automate Excel itself - i.e. Excel is an Automation server to which you can connect and control it.
Try looking here for a start: http://www.djpate.freeserve.co.uk/AutoExcl.htm I've done it myself - e.g. I wrote an app to pull comments out of a Word document (again, automating Word), and stick them into an Excel spreadsheet. MSDN might also be useful for documenting the Excel automation interface. HTH, Conor -----Original Message----- From: [EMAIL PROTECTED] I want to read in a spreadsheet (could be just a csv), check certain columns versus what's on a database, and add an additional column or 2 to the spreadsheet if I find a discrepancy (in the spreadsheet vs the database) and then write back out the updated csv. I haven't been developing in Delphi long and this is the first time I've wanted to read a text file. Looking at help, I'm thinking TstringStream would probably be a start. Unless someone can suggest something more elegant or better fitted to the task? Thanks for any ideas. Dave --------------------------------------------------------------------------- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
