Re: How to create an Excel with multiple Tabs from AS400?

+1 for SQL2JXL - it is really fast. It, however, only produces XLS - not XLSX. I think he also has an SQL2POI that is just as fast. That one still produces only XLS, not XLSX - but that can be changed - the first one uses a Java class that doesn't appear to being maintained for newer Excel releases. To the best of my current knowledge, that is.

Giuseppe's are very fast - it is actually a single class that is called once from RPG - Scott's are repeatedly called and I think that this makes it slower. It might not be perceivable on a really fast machine, but it is on our dev LPAR for sure.

Vern

On 10/7/2013 12:14 PM, Peter Dow wrote:

Take a look at either Scott Klement's POI/HSSF service program
(http://www.scottklement.com/poi/), or Giuseppe Costagliola's SQL2JXL
command
(http://www.mcpressonline.com/tips-techniques/microsoft/techtip-excel-flies-higher-with-jexcelapi.html).

Scott's service program is great for detailed control over the
spreadsheet; Giuseppe's is great for quick creation or addition to a
spreadsheet from any SQL SELECT statement.

--
*Peter Dow* /
Dow Software Services, Inc.
909 793-9050
petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx>/

On 10/7/2013 7:50 AM, Nisha Ramesh wrote:

Hi all,

I have a requirement to create a multi tab Excel sheet from AS400. The tabs
are based on 2 different files which are different in structure. To create
a single tab excel, i have done with CrtCsvDta and then ftp the file in the
desired location and access the csv from that location using iseries
navigator. I know this technique wont work for muli tab Excel sheet.
Anybody came across same situation ?

Regards
Nisha