Thanks On Thu, Sep 22, 2011 at 3:50 AM, Nick Burch <[email protected]> wrote: > 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] > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
