Hi,

Could I make a request for a small change to SheetUtil.getColumnWidth?
Headers rows in a sheet often contain titles that are expected to run over into subsequent columns, so I'd like to be able to ignore some rows at the start. Measuring every single cell can be prohibitively expensive for large sheets, and typically the results are no better than can be obtained from the first few rows*.

So it would be really useful to be able to provide a range of rows to getColumnWidth and have it only consider cells in those rows. To work around this at the moment I've written a FilteredSheet class, that wraps a Sheet but returns an iterator that only includes rows in the range.

Thanks.

Jim

* Yes, there are worries of falling into the same pit as Excel text import that only considers the first 8 rows, but the result is less problematic here.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to