On Wed, 21 Sep 2011, Alec Swan wrote:
Could anybody provide some ideas on how to replace all data on one of
the sheets of an Excel file with data from a CSV file?
Firstly you'll need something to read CSV files. There are lots of
libraries out there (including Commons CSV from Apache), pick one that
works for you
Then, create a new sheet / clean an existing one
Finally, iterate through the csv, creating rows and cells and populating.
Job done!
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
