Re: IBM i database to Excel spreadsheet

Wow, those benchmarks are old. Does SQL2XLS still use POI 2.x? In fact POI 3.16 was released just recently, though it will require some refactoring to make it work with Scotts header files, I suspect POI is much faster than it was back then. I know that there have been some speed fixes made in the interim. And you should be able to go all the way up to 3.14, or 3.15 with Scotts header files.

Mark Murphy
Atlas Data Systems
mmurphy@xxxxxxxxxxxxxxx


-----Peter Dow <petercdow@xxxxxxxxx> wrote: -----
To: midrange-l@xxxxxxxxxxxx
From: Peter Dow <petercdow@xxxxxxxxx>
Date: 11/30/2016 01:32PM
Subject: Re: IBM i database to Excel spreadsheet


And SQL2JXL by the same author as SQL2XLS, but much faster. See

http://www.mcpressonline.com/forum/forum/operating-systems/microsoft-aa/16563-techtip-excel-flies-higher-with-jexcelapi/page2

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


On 11/30/2016 9:32 AM, Rob Berendt wrote:

Search also:
SQL2XLS

Expect a recommendation on how easy it is to use Python on IBM i to
generate an Excel spreadsheet.

But a coworkers here have done some wonderful stuff using Scott Klement
techniques for generating Excel files.
http://www.scottklement.com/presentations/#RPGHSSF


Rob Berendt