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]