Re: How to create an Excel with multiple Tabs from AS400?

[Steve Jones <sjones@xxxxxxxxxxxxxxx>]

Check out Scott Klements POI stuff - http://www.scottklement.com/poi/


On Mon, Oct 7, 2013 at 10:52 AM, Gary Thompson <gthompson@xxxxxxxxxxx>wrote:

> My guess is .csv is only text therefore no such thing
> as a "tab" exists in that "Windows file format"
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Nisha Ramesh
> Sent: Monday, October 07, 2013 8:50 AM
> To: RPG programming on the IBM i / System i
> Subject: How to create an Excel with multiple Tabs from AS400?
>
> Hi all,
>
> I have a requirement to create a multi tab Excel sheet from AS400. The
> tabs are based on 2 different files which are different in structure. To
> create a single tab excel, i have done with CrtCsvDta and then ftp the file
> in the desired location and access the csv from that location using iseries
> navigator. I know this technique wont work for muli tab Excel sheet.
> Anybody came across same situation ?
>
> Regards
> Nisha
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (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 (AS/400 and iSeries) (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.