Re: POI - is 3.6 the latest supported version?

The old Excel format (sometimes called 'binary' format...the technical name is BIFF8 in an OLE2 compound document) with the extension .XLS is a really ugly mess of a format.

But all versions of Excel in the last 12 years or so support the newer .XLSX format, which is just zipped XML files, so generating these yourself isn't so hard.


On 6/25/2015 3:28 PM, broehmer@xxxxxxxxxxxxxxx wrote:

Wow. Just can't imagine what it would take or what it
would look like. I've always thought that the way POI
addresses their solution Excel had to be a real mess
underneath. But then I'm just an average RPG programmer
looking for elegant ways to solve back office problems.
Hope he decides to go public with it.


Bill Roehmer
Senior Pgmr/Analyst
The C.D. Hartnett Company

817 594-3813 ext. 1631


"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify
the sender by reply e-mail, and then destroy all copies of the
transmission."






From: John Yeung <gallium.arsenide@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 06/25/2015 03:19 PM
Subject: Re: POI - is 3.6 the latest supported version?
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



On Thu, Jun 25, 2015 at 3:59 PM, <broehmer@xxxxxxxxxxxxxxx> wrote:

RPG Open access handler.

Um, I doubt he built his Excel stuff as an OA handler. I would think
he made a service program (or multiple service programs) that are
called the usual way.

John Y.