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

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

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.