RE: Getting a file to excel

That only holds true for text files and there is a work around for it
but I don't recall what it is (searching on WEB-400 might turn it up).
For true Excel files, you can specify the data type for each cell and
it's not a problem.

Matt

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Wednesday, June 28, 2006 4:02 PM
To: RPG programming on the AS400 / iSeries
Subject: Re: Getting a file to excel


Be careful with attempting to put data into an excel spreadsheet.
One of the problems we have (and if anyone can post an answer to this,
we
would be very grateful), is that a credit card number is held in a 19
digit
numeric field. Once this field is placed into an excel spreadsheet,
excel
will only display the first 15 numbers, 0 filling the rest - NO MATTER
what
the rest is.
I know this is a problem with excel, but, like I said,  if anyone has an
answer....


Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx


 

             steema@diskhaven.

             com

             Sent by:
To 
             rpg400-l-bounces@         rpg400-l@xxxxxxxxxxxx

             midrange.com
cc 
                                       midrange-l@xxxxxxxxxxxx

 
Subject 
             06/28/2006 09:16          Getting a file to excel

             AM

 

 

             Please respond to

              RPG programming

              on the AS400 /

                  iSeries

             <rpg400-l@midrang

                  e.com>

 

 





HI What are some of the methods in taking a file that was generated by
an
RPG program and getting it to the user in an Excel Worksheet file?

It seems to be a straightforward file. Is there a preferred method. Any
issues w/ v5.3 and the client access ?

Thanks,
Steve
--
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.