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.
-----Original Message----- From: Jörn Franke [mailto:[email protected]] Sent: Tuesday, July 18, 2017 6:05 PM To: POI Users List <[email protected]> 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 > On 18. Jul 2017, at 22:37, oogolov <[email protected]> wrote: > > Is it possible to download only part of huge excel file to obtain > column headers and first 10 records? > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/download-only-part-of-xlsx-fil > e-to-obtain-column-header-tp5728272.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] For additional > commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
