poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Stadler <dominik.stad...@gmx.at>
Subject Re: Detect or remove auto filter
Date Fri, 21 Jul 2017 13:49:43 GMT
Hi,

HSSF/xls are a binary format, you probably need to take a look at the code
in HSSFSheet.setAutoFilter() to see how these are stored in this binary
format.

The Spec [MS-XLS] at
https://msdn.microsoft.com/en-us/library/cc313105%28v=office.12%29.aspx
will contain the canonical description of how these are supposed to be
stored, albeit in a somewhat convoluted and hard to read form.

Dominik.


On Fri, Jul 21, 2017 at 2:59 PM, pj.fanning <fanningpj@yahoo.com> wrote:

> Hi Samuel,
> getCTWorksheet only works for xlsx files as it relies on the fact that
> underlying xlsx data is in XML files in ooxml format.
>
>
>
> --
> View this message in context: http://apache-poi.1045710.n5.
> nabble.com/Detect-or-remove-auto-filter-tp5728276p5728279.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
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message