- Objective

To programatically import csv files into excel, and have the ability to 'update' them, ie, append new data to the end of the imported csv's.

- Using the example project

1.  Install the TExcelCSV component.

2.  Open and compile/run the project.

3.  Click on Import (and wait for the 'Done' message).  This will create the file csvtest.xls in the program directory and import the csv files 'ibm' and 'msft'.  You might want to open the spreadsheet at this point and have a look.

4.  Close the spreadsheet if you opened it.  Click on append and wait for 'Okay'.  This will append a line of data to each worksheet in csvtest.xls.  Take a look.

Alternatively, you can just open the project and look at the code in ExcelCSV.pas for some examples.

*IMPORTANT*

This is not production quality code!  I think the principles are accurate, and can serve as examples for importing, updating, formatting ranges, etc but the component is not robust (does not gracefully handle errors).  Please use appropriately.

THANKS!

Many thanks to D Pate and Glynn from borland.public.delphi.oleautomation for the pointers!