You would normally never bother setting the data type for an empty cell as doing this requires you to create a record for each empty cell and that will massivly increase the file size of the workbook. On a sheet there are something like sixty five thousand rows and creating a record for each row and each emty cell on that row will lead to a potentially bloated file and slow your application somewhat.
Is there any reason why these empty cells must have their data type set? When Excel marks a cell as 'General' that means it can accept any value and when it is populated by the user, the application - Excel - will ensure that features are automatically configured to suit the type of data the user is entering. By this, I mean that numeric value will be right aligned, for example, and I do not know that setting the data type to text will prevent this from happening. Yours Mark B -- View this message in context: http://apache-poi.1045710.n5.nabble.com/setting-column-to-be-test-in-XSSF-tp4296158p4297528.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]
