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

[Greg Wilburn <gwilburn@xxxxxxxxxxxxxxxxxxxxxxx>]

Vern, 

I am not familiar with those other tools.  I know SQL2XLSX uses the Excel POI java classes called from an RPGLE/CLLE programs.  If you download, you get the source code.

In fact, I'm fairly certain it works a lot like CGIDEV2 because I've encountered conflicts running both methods in the same job stream.

I agree that CGIDEV2 gives you a lot more flexibility, but SQL2XLSX is just very simple to use and you can store thinks like column headings, macros and filters in templates you control with Excel.

Greg

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Vernon Hamberg
Sent: Friday, October 25, 2019 9:51 AM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: How to apply filter to a sheet in RPG. (HSSFR4, POI, Spreadsheet)

To add more on performance - SQL2JXL and SQL2POI have pretty good 
performance - because they use a Java class that processes a SELECT 
statement in one call - not the many method calls used in the POI 
service program.

Vern

On 10/25/2019 8:48 AM, Vernon Hamberg wrote:
> +1
>
> Greg, is SQL2XLSX is similar to SQL2JXL? Or SQL2POI? We use the former 
> often for fairly simple data dumps with column headings - but it's 
> limited to the older XLS format.
>
> I find the CGIDEV2 method offers the possibility of doing almost 
> anything Excel itself can do, albeit at possibly more developer effort 
> at the start.
>
> Cheers
> Vern
>
> On 10/25/2019 8:37 AM, Greg Wilburn wrote:
> > I haven't followed this thread... but here's my 2 cents:
> >
> > We create XLSX files in two ways.
> > 1. Using CGIDEV2, and
> > 2. Using SQL2XLSX (command)
> >
> > The second option allows you to generate XLSX from any SQL 
> > statement.  You can also have XLSX "template" files that it merges 
> > the data into.
> >
> > I typically use #2 when I need to filter or run a macro.  I save the 
> > filter/macro in the template and then fill it with data using SQL2XLSX.