poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Samuel Stein <st...@ga-gmbh.de>
Subject Re: Detect or remove auto filter
Date Fri, 21 Jul 2017 07:53:24 GMT
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
>>



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