Re: Iseries file to an Excel spreadsheet

[Gqcy <gmufasa01@xxxxxxxxx>]

William,

If the requirement is to reproduce an actual Microsoft Excel "xls" file, 
via a program, you should google: HSSFCGI/TABLEXLS

-gerald


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