RE: download only part of xlsx-file to obtain column header
Y. +1 for the streaming/event API. It can be tricky with the SharedStrings file. When I implemented a "stop after the first 10 rows" reader with the Streaming API, I found that it didn't help with speed on some files...what was happening was that these files contained large narratives, and the entire SharedStrings component was being read in and stored in memory.
From: Jörn Franke [mailto:[hidden email]]
Sent: Tuesday, July 18, 2017 6:05 PM
To: POI Users List <[hidden email]>
Subject: Re: download only part of xlsx-file to obtain column header
You mean download or read?
You can use the streaming / event API for low footprint reading