Re: Reading excel via ILE RPG

John,

Yeah I just saw what Buck wrote. I kinda like that idea.
Never hurts to ask in ignorance. Might just learnt a
thing or three.

Bill





From: John Yeung <gallium.arsenide@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 02/08/2017 05:00 PM
Subject: Re: Reading excel via ILE RPG
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



On Wed, Feb 8, 2017 at 5:40 PM, <broehmer@xxxxxxxxxxxxxxx> wrote:

That makes some sense. But what about
some other format that might not be so
forgiving? Again, just a thought. Maybe
open with Notepad ++.

Well, the workbook isn't going to open as-is directly in Notepad++ (or
any other text editor). Buck described how to go about extracting the
XML contents of the workbook, which could then be examined in
Notepad++ (or any other text editor; though frankly, for this purpose
there's not much advantage to using anything other than Notepad).

But it really shouldn't come to that. I mean, the Excel GUI is not
***THAT*** opaque. You should be able to figure out what the value is
from within Excel itself. But you have to know your way around
formatting.

John Y.