Dec 3, 2012 at 1:51 AM

Due to the streaming nature of the implementation, there are the following limitations when compared to XSSF:

  • Only a limited number of rows are accessible at a point in time.
  • Sheet.clone() is not supported.
  • Formula evaluation is not supported

See more details at SXSSF How-To

The table below synopsizes the comparative features of POI's Spreadsheet API:

Spreadsheet API Feature Summary

Spreadsheet API Feature Summary