An InputStream requires more memory as it has to buffer the whole file
(written by lawrence krubner, however indented passages are often quotes). You can contact lawrence at: lawrence@krubner.com
This is exactly the opposite of what I’ve always understood, and what I’ve read elsewhere:
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?
Crazy.
Source
December 16, 2018 9:06 am
From lawrence on Yair Lapid: What does it say about us that Israel has become the only democracy in the world in which Jews don’t have freedom of religion?
"Cat Mara, thank you for catching that. I've fixed it now. (The URL was a "v" by mistake. Looks like I was tryi..."