Created attachment 30118 [details] Modifies SXSSFRow to accept start and end span properties. Also, modifies SheetDataWriter to write (if present) these properties to row tag. Currently SXSSFRow does not allow to specify "spans" attribute for a row. Even though it is an optional attribute but excel uses it for optimization internally. The patch allows SXSSFRow to accept start span and end span properties from the user (optional). If this property is specified SheetDataWriter.writeRow(int rownum, SXSSFRow row) will add this attribute while writing the row element. Output: <row r="8" spans="4:6"> (if spans are specified) <row r="8"> (if spans are not specified)
Ideally, before applying this, we would some unit tests to verify it works correctly. The other concern is that it's SXSSF only, and something like this should probably be present for both SXSSF and XSSF, so ideally we'd want a patch that updates it for both