Re: Iseries file to an Excel spreadsheet

Willie

<verndor response>
If you are open to a commercial solution, we have a couple options. Our RPG2SQL Integrator has a CL command that exports a PF or LF to a spreadsheet. It formats columns according to the data type on the i - no leading zeroes lost in zip codes, for example. The command is built on the Excel functionality that is extensive, if you need that in the future, as well as the remote database functionality.

We also have our DataExport product, which can convert files or SELECT output to either spreadsheets or SYLK format - the latter does the column formatting by data type, as described above.

If you want to see more, feel free to contact me at vern@xxxxxxxxxxxxxxx or call 888.rjs.soft and ask for me or sales.
</verndor response>

HTH
Vern

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

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