poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Allison, Timothy B." <talli...@mitre.org>
Subject RE: download only part of xlsx-file to obtain column header
Date Tue, 25 Jul 2017 00:37:51 GMT
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:jornfranke@gmail.com] 
Sent: Tuesday, July 18, 2017 6:05 PM
To: POI Users List <user@poi.apache.org>
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 <oogolov@ukr.net> 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: user-unsubscribe@poi.apache.org For additional 
> commands, e-mail: user-help@poi.apache.org
> 

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message