RE: AS400 to EXCEL

[MEovino@xxxxxxxxxxxxxxxxx]

I know I point that out every time.  As soon as you attempt to export a
file with New Jersey zip codes in it, you will see that Excel will not keep
the leading zeros of a CSV file, no matter what you do.  Believe me, I've
tried.

AFAIK, there are two products out there that will create Excel files on the
400.  One is SEQUEL from ASC, and the other is CVTDBFXLS from Kemetech.  We
didn't need all the query tools of SEQUEL (or the cost), so we bought the
stuff from Kemetech.  Works nicely.  If a field is defined as alpha in your
file, CVTDBFXLS will create cells formatted as text.

Mike E.



                                                                                
                                    
                    rob@xxxxxxxxx                                               
                                    
                    Sent by:                  To:     RPG programming on the 
AS400 / iSeries                        
                    rpg400-l-bounces@xx        <rpg400-l@xxxxxxxxxxxx>          
                                    
                    drange.com                cc:                               
                                    
                                              Subject:     RE: AS400 to EXCEL   
                                    
                                                                                
                                    
                    05/13/2003 03:52 PM                                         
                                    
                    Please respond to                                           
                                    
                    RPG programming on                                          
                                    
                    the AS400 / iSeries                                         
                                    
                                                                                
                                    
                                                                                
                                    




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.


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