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: [email protected] For additional commands, e-mail: [email protected]
