Re: How to apply filter to a sheet in RPG. (HSSFR4, POI, Spreadsheet)

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

I was able to make Excel open a workbook with filters already applied, so
you should be able to to do what you are asking for using POI.

On Thu, Oct 31, 2019 at 3:14 PM Mark Murphy <jmarkmurphy@xxxxxxxxx> wrote:

> I just want to let you all know, that if you can do it in Excel, you can
> probably do it in POI. If you can't do it in Excel, then there is nothing
> you can do about it. POI just writes the spreadsheet in Excel format. So if
> you can set up your filter in Excel, close the workbook, and reopen it, and
> the filters are still there, then you can look at the XML and determine
> what to add, and you can likely do that with POI. Maybe not at the higher
> level XSSF classes, but definitely with the CT_ classes. Using the CT
> classes, though, requires intimate knowledge of the EXCEL format.
>
> On Fri, Oct 25, 2019 at 10:30 AM John Rusling via RPG400-L <
> rpg400-l@xxxxxxxxxxxxxxxxxx> wrote:
>
> > Thanks Vern, that'd be great!
> >
> > John
> >
> >
> > <snip>
> > Hi John
> >
> > At COMMON I give a couple presentations on using CGIDEV2 to create XLSX
> > spreadsheets, including the packaging.
> >
> > There is also a lab, I have materials for setting it up on your system.
> >
> > performance is good, creating the templates can take time, esp. when
> > someone wants things changed. Never happens, right? unless at Area 51!
> >
> > I'll send it when I get to work.
> >
> > Cheers
> > Vern
> > </snip>
> > <br />
> > The information in this email is confidential and may be legally
> > privileged.
> > It is intended solely for the addressee. Access to this email by anyone
> > else is
> > unauthorized. If you are not the intended recipient, any disclosure,
> > copying,
> > distribution or any action taken or omitted to be taken in reliance on
> > it, is
> > prohibited and may be unlawful.
> > --
> > This is the RPG programming on IBM i (RPG400-L) mailing list
> > To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> > To subscribe, unsubscribe, or change list options,
> > visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> > or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> > Before posting, please take a moment to review the archives
> > at https://archive.midrange.com/rpg400-l.
> >
> > Please contact support@xxxxxxxxxxxx for any subscription related
> > questions.
> >
> > Help support midrange.com by shopping at amazon.com with our affiliate
> > link: https://amazon.midrange.com