From the documentation I came to know that SXSSFCell and XSSFCell are the implementing classes of Cell, but I am trying to understand the difference between different implementations. If I want to export data to excel, so which Cell implementation should I use? What exactly is the difference between SXSSFCell and XSSFCell ?
What is the difference between Cell, SXSSFCell and XSSFCell?
Viewed 47
1 Answers
Well in summary SXSSFCell is just an extension of XSSFCell. When to use it is making a large spreadsheets. If you are not making a huge spreadsheets then use only XSSFCell.
Check more the documentation:
SXSSF is an API-compatible streaming extension of XSSF to be used when very large spreadsheets have to be produced, and heap space is limited. SXSSF achieves its low memory footprint by limiting access to the rows that are within a sliding window, while XSSF gives access to all rows in the document. Older rows that are no longer in the window become inaccessible, as they are written to the disk.
Related