Re: Create Excel Spreadsheet from AS/400 Data & Email it

A couple potential pitfalls when using CSV in Excel:

1.  If all the data in a field are numeric digits, Excel will treat it as a
numeric field.  So when you export a file with zip codes, New Jersey's zip
codes will lose the leading zero.  If you put the field value in quotation
marks, Excel will still treat it as numeric.  If you put an apostrophe in
front of the field value, Excel will show the apostrophe (but if you use
this old Lotus 1-2-3 trick in an XLS file, it will treat the cell as text).

2.  Excel has a "feature" that displays all numeric values greater than a
certain number of digits (it's either 12 or 15, I can't remember off the
top of my head) in scientific notation.

That's why we bought the stuff from Kemetech.  Sooner or later, one of
these two things will jump up and bite you in the a**.

Mike E.




                                                                                
                                   
                    "alan"                                                      
                                   
                    <steelville@xxxxxxx       To:     "RPG programming on the 
AS400 / iSeries"                     
                    om>                        <rpg400-l@xxxxxxxxxxxx>          
                                   
                    Sent by:                  cc:                               
                                   
                    rpg400-l-bounces@xx       Subject:     Re: Create Excel 
Spreadsheet from AS/400 Data & Email   
                    drange.com                 it                               
                                   
                                                                                
                                   
                                                                                
                                   
                    04/02/2003 10:49 PM                                         
                                   
                    Please respond to                                           
                                   
                    RPG programming on                                          
                                   
                    the AS400 / iSeries                                         
                                   
                                                                                
                                   
                                                                                
                                   




Me, too. <g>

Here's a really, really good FAQ on the subject:

http://faq.midrange.com/data/cache/67.html

But I'm having trouble applying it. My users will be
satisfied with comma-delimited, which imports directly into
Excel, and that's easy enough, but now I'm trying to
automate it for download. Click on the desktop icon that
runs the batch file that runs the script. Trouble is, typing
in "as is" in the FAQ, it's giving me a problem with the
format for Win98.

Clicking on the icon, I get the "MS-DOS Prompt" window
coming up with "Invalid statement or command".

Now, typing it in at the command prompt runs the batch file,
but I get "Error opening script file ftpscript.txt."

- Alan

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