March 17th, 2017
(written by lawrence krubner, however indented passages are often quotes). You can contact lawrence at: email@example.com
When opening a workbook, either a .xls HSSFWorkbook, or a .xlsx XSSFWorkbook, the Workbook can be loaded from either a File or an InputStream. Using a File object allows for lower memory consumption, while an InputStream requires more memory as it has to buffer the whole file.
The stream requires more memory? That is crazy. It’s a stream. And what is a File object if not the whole File all at once?