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.
midrange.com
