poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Beardsley <markbrd...@tiscali.co.uk>
Subject Re: large xssf files
Date Wed, 20 Oct 2010 15:04:02 GMT

How complex is the formatting? If you open a blank excel document, set the
widths of columns and apply formatting to them then import a CSV file into
this document, the formatting rules will be applied to the data as the sheet
is populated. This will only work for simple formatting of course, if you
need to have, for example, a totals row at the end of the document and the
values for this row must be calculatyed from the data you are reading in
then this presents more of a problem.

You might want to look at using an Excel macro to open the CSV file and
populate the workbook. A macro would be able to ocate a file on your
machine, to open it, read the data and populate the workbook; indeed, macros
can do anything you - a user - could. Further, this macro can be set to run
when the user opens the workbook and it could be 'signed' so that they were
unawar of it. The macro recorder could help you get started with this and
there are plenty of web sites offering VBA code and advice on the web.
View this message in context: http://apache-poi.1045710.n5.nabble.com/large-xssf-files-tp3227625p3228800.html
Sent from the POI - User mailing list archive at Nabble.com.

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message