Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Subject: Re: Detect or remove auto filter
To: user@poi.apache.org
References: <2395f948-fbbc-5f70-d2a4-ea1047e3ada3@ga-gmbh.de> <CAEwphwob9nxx4vwcDeH9uTZgp0vAfR=w2sdAnAg7JW87+_5evw@mail.gmail.com>
From: Samuel Stein <stein@ga-gmbh.de>
Organization: =?UTF-8?Q?Geb=c3=a4ude_Automatisierung_GmbH?=
Message-ID: <69475e64-a884-5fef-d33e-1385cc223816@ga-gmbh.de>
Date: Fri, 21 Jul 2017 09:53:24 +0200
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.2.1
MIME-Version: 1.0
In-Reply-To: <CAEwphwob9nxx4vwcDeH9uTZgp0vAfR=w2sdAnAg7JW87+_5evw@mail.gmail.com>
Content-Type: multipart/alternative; boundary="------------D87649A9AC42A05DE2977D93"
Content-Language: en-US
archived-at: Fri, 21 Jul 2017 07:53:37 -0000

--------------D87649A9AC42A05DE2977D93
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

Hello Greg,

thanks for the fast answer and the good example.

I forgot to mention that i have an .xls file and not an .xlsx.
Is there also an internal api for auto filter?


Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte Informationen enthalten.
Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben,
informieren Sie bitte sofort den Absender und vernichten Sie diese Mail
Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet.

This e-mail may contain confidential and/or privileged information
If you are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail
Any unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.

On 20.07.2017 23:51, Greg Woolsey wrote:
> You have to go down to the CT* classes for that info, POI doesn't have a
> high-level API for it yet.  Note this is a per-sheet setting, not
> per-workbook.
>
> XSSFWorksheet xw = getTheWorksheet();
> if (xw.getCTWorksheet().isSetAutoFilter()) {
>    CTAutoFilter af = xw.getCTWorksheet().getAutoFilter();
> }
>
> You can then use it's ref property directly and parse it as a cell range
> reference, or go look for the built-in named range that matches it (or
> could be for a different advanced filter, see the JavaDoc):
>
> org.apache.poi.xssf.usermodel.XSSFName.BUILTIN_FILTER_DB
>
> All this can be inferred by following the source code in
> XSSFSheet.setAutoFilter(CellRangeAddress)
>
>
> On Thu, Jul 20, 2017 at 6:05 AM Samuel Stein <stein@ga-gmbh.de> wrote:
>
>> Hello folks,
>>
>> i have a question regarding Auto Filter. As far as i can see POI
>> supports right now only setting an auto filter.
>>
>> Is there a way to detect if the spreadsheet has an active auto filter
>> set and/or remove auto filter?
>>
>> Thanks in advance
>>
>>
>> Samuel
>>
>> --
>> Diese E-Mail könnte vertrauliche und/oder rechtlich geschützte
>> Informationen enthalten.
>> Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich
>> erhalten haben,
>> informieren Sie bitte sofort den Absender und vernichten Sie diese Mail
>> Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind
>> nicht gestattet.
>>
>> This e-mail may contain confidential and/or privileged information
>> If you are not the intended recipient (or have received this e-mail in
>> error)
>> please notify the sender immediately and destroy this e-mail
>> Any unauthorised copying, disclosure or distribution of the material in
>> this
>> e-mail is strictly forbidden.
>>
>>
>> GA Gebäude Automatisierung GmbH
>> Technisches Büro Berlin
>> Bundesallee 89
>> 12161 Berlin
>>
>> Amtsgericht Dortmund, HRB 9327
>> Geschäftsführer Rüdiger Plett
>>


--------------D87649A9AC42A05DE2977D93--