RE: AS400 to EXCEL

["Haas, Matt" <Matt.Haas@xxxxxxxxxxxxxxxxxxx>]

Creating an Excel file isn't a simple thing. Excel (and Word and probably Power 
Point) use what's called an "OLE2 Compound Document Format" file which is 
basically a file version of a COM object. Creating one of these files is 
extremely complicated. I think there are third part programs that can do this 
(I couldn't tell you names off the top of my head). If you know Java and you 
don't want to spend money on it, you can use an Apache package called POI to do 
Word and Excel.

Matt

-----Original Message-----
From: hrishikesh kotwal [mailto:hdkotwal@xxxxxxxxxxx]
Sent: Tuesday, May 13, 2003 3:20 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: RE: AS400 to EXCEL


   Hi all:

    

   I did find a lot interesting things @ midrange regarding converting PF to
   an Excel file. But still a few questions remain:

   Using CPYTOIMPF, I was able to create Source Member containing formatted
   data i.e. character strings in ' " ' and numbers separated by ' , '.

   But I would like to generate an Excel file from this member without any
   human intervention i.e. programmatically. How do I achieve that?

    

   Please advise.

   Regards,
    
   Hrishikesh Kotwal
    
   >From: Buck Calabro <BUCK.CALABRO@xxxxxxxxxxxx>
   >Reply-To: RPG programming on the AS400 / iSeries <RPG400-L@xxxxxxxxxxxx>
   >To: RPG programming on the AS400 / iSeries <RPG400-L@xxxxxxxxxxxx>
   >Subject: RE: AS400 to EXCEL
   >Date: Tue, 13 May 2003 08:07:53 -0400
   >
   >The FAQ has some entries dealing with this. http://faq.midrange.com
   > --buck