RE: AS400 to EXCEL

And the reply that comes up on that all the time is if you have a string 
field that just happens to be all numeric, it makes it numeric.  Or some 
such argument.  I think that's in the archives also.  I just remember 
something like that.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




"Bob cozzi" <cozzi@xxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
05/13/2003 02:46 PM
Please respond to RPG programming on the AS400 / iSeries
 
        To:     "'RPG programming on the AS400 / iSeries'" 
<rpg400-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        RE: AS400 to EXCEL


Excel will read the CSV file that CPYTOIMPF generates


Bob Cozzi
Cozzi Consulting
www.rpgiv.com


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of hrishikesh kotwal
Sent: Tuesday, May 13, 2003 2: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.




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