×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
midrange.com
