Re: Iseries file to an Excel spreadsheet

The old standby CPYTOIMPF command might do the trick for you if you want to
replace the entire file. It reads a database file and outputs a
comma-delimited (well, anything-delimited really) or "columnar" stream file
in the IFS that you pick up on your PC. Make sure to pick a suitable output
CCSID and codepage.

Stu



On Tue, Feb 8, 2011 at 15:50, Willie J. Moore <WJMoore@xxxxxxxxxxxx> wrote:

DCL = Declare CL Variable.
I want to do the update from within an CL.


William Moore
California Fine Wire
805-489-5144
wjmoore@xxxxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Pete Helgren
Sent: Tuesday, February 08, 2011 1:41 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: Iseries file to an Excel spreadsheet

Depending upon the approach, Midrange-L may be the best place to post.....

There is quite of bit of history in the archives on the subject which is
may be why there wasn't much of a response.

There is a data tool for Excel that comes as part of IBM i Access. If I
recall correctly, there is a way to define the range of cells within the
sheet that you want to update and all you need to do (again, if I recall
correctly) is to open the spreadsheet and that will trigger a query that
will update the sheet. I am a little fuzzy on those details because I
abandoned MS Office products completely about two years ago.

You could write an RPG program that would update the sheet as well.
Scott Klement has some excellent tools that you can use to manipulate
spreadsheet data from RPG. http://www.scottklement.com/poi/

There are many ways to skin the cat. I don't know where (OS) and
how(language) you want to update the spreadsheet, but updating the
spreadsheet is more difficult than creating one so you'll have a bit of a
challnge to come up with an approach that works in your particular scenario.

My only question was your reference to a "DCL", what is that?

Pete Helgren
Value Added Software, Inc
www.asaap.com
www.opensource4i.com


On 2/8/2011 2:07 PM, Willie J. Moore wrote:

I have posted this on the Midrange-L site with no response. I thought I

would try here and see if I have better luck.

I have a file on the iseries and an Excel spreadsheet.
Spreadsheet name=open percentages.xa.2011, worksheet name=wek%2003.
I want to copy the iseries file into the spreadsheet, replacing the

data in the worksheet. I have a 'DCL' with the spreadsheets name. I am
having trouble replacing the spreadsheet data with the file data.

File layout: date, total orders, total items, prod due& prod due %.
Excel spreadsheet: date, total orders, total items, prod due& prod due

%.

Any help would be greatly appreciated.

Thank you,

William Moore
California Fine Wire
805-489-5144
wjmoore@xxxxxxxxxxxx

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.