RE: AS400 to EXCEL

Give it a whirl ... or at least the CPYTOIMPF portion ;)


PGM                                                         
                                                            
CPYTOIMPF  FROMFILE(yourLib/yourFile) +                       
             TOSTMF('/QDLS/yourFolder/yourFile.CSV') +                
             MBROPT(*REPLACE) STMFCODPAG(*PCASCII) +        
             RCDDLM(*CRLF)                                  
                                                            
STRPCO                                                      
MONMSG     MSGID(IWS4010)                                   
STRPCCMD   PCCMD('Start  Q:\yourFolder\yourFile.CSV') PAUSE(*NO)      
                                                            
ENDPGM                                                      





-----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
   >_______________________________________________
   >This is the RPG programming on the AS400 / 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.
   >

     ----------------------------------------------------------------------

   Dreaming of a holiday? Make it happen. In Switzerland!
_______________________________________________
This is the RPG programming on the AS400 / 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.