Re: Import Excel file

Gad,

Check out the easy400.net site. They have a bunch of (free?) utilities that
allows you to read and from and to Excel files.

HTH,
Luis

Sent from my Moto G phone. Please excuse my brevity.

On Mon, Jan 17, 2022, 10:35 Gad Miron <gadmiron@xxxxxxxxx> wrote:

Many thanks to all responders

I did suspect that no native IBM Excel-import method is to be found

Luckily, our emulation package (BOSaNova) comes with a built-in file
transfer utility
that supports Excel (import & export) and can be invoked on the user's PC
via STRPCCMD

Not as elegant as I wanted but feasible.

Gad

message: 1
date: Sun, 16 Jan 2022 13:10:29 -0600
from: Bryan Dietz <bdietz400@xxxxxxxxx>
subject: Re: Import Excel file

If you have ACS ?installed? in the IFS there may be the opportunity to

use

the batch upload process.

I?ve not tried running batch upload from the IFS, but it seems it should
be possible.

Bryan

On Jan 15, 2022, at 11:22 PM, Gad Miron <gadmiron@xxxxxxxxx> wrote:

Hello sages

I need to adapt a process that imports (CPYFRMIMPF) a tab delimited

file

So that it imports an Excel file.

Is there an equivalent CPYFRMEXLF ? (-:
Or perhaps a method to programmatically convert excel into a Tab

delimited

/ | delimited file ?

TIA
Gad
--

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com