Re: Iseries file to an Excel spreadsheet

It is maped from another server to my computer. The other server is called 'iriduma'
I want to replace the whole contents of the file.


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 Monnier, Gary
Sent: Tuesday, February 08, 2011 1:21 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: Iseries file to an Excel spreadsheet

William,

Where does the spreadsheet reside? In the iSeries' IFS or on some other server?

Also, how are you trying to refresh the data? While in Excel or are you just wanting to replace the contents of the file?


Gary Monnier

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Willie J. Moore
Sent: Tuesday, February 08, 2011 1:08 PM
To: 'rpg400-l@xxxxxxxxxxxx'
Subject: Iseries file to an Excel spreadsheet

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.