You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by oogolov <oo...@ukr.net> on 2017/07/18 20:37:24 UTC
download only part of xlsx-file to obtain column header
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-file-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
RE: download only part of xlsx-file to obtain column header
Posted by "Allison, Timothy B." <ta...@mitre.org>.
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 <us...@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 <oo...@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
Re: download only part of xlsx-file to obtain column header
Posted by Jörn Franke <jo...@gmail.com>.
You mean download or read?
You can use the streaming / event API for low footprint reading
> On 18. Jul 2017, at 22:37, oogolov <oo...@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-file-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