Re: AS400 to EXCEL

["Eric A. Wolf" <eric_a_wolf@xxxxxxxxxxx>]

Booth,
I am using the CRTCSVF utility which allows the output of Column headings
and Excel still suppresses the zeros.  Excel also right justifies the column
if the cell "looks" numeric even when some of the cells are alpha.

Besides that, the CRTCSVF utility along with the SNDM utility works great
for my customer.  We use both of them constantly.  Now I am writing a
utility to combine the two for sending query results as a .csv to email.

Eric

----- Original Message -----
From: "Booth Martin" <Booth@xxxxxxxxxxxx>
To: <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, May 20, 2003 11:30 AM
Subject: Re: AS400 to EXCEL


> I was just wondering...
>
> what if the first record had the column heading names in it?  That'd be
easy
> to program.  Would Excel then decide that all the columns are character,
and
> move numbers in as text?
>
>
>
> ---------------------------------------------------------
> Booth Martin   http://www.MartinVT.com
> Booth@xxxxxxxxxxxx
> ---------------------------------------------------------
>
> -------Original Message-------
>
> From: RPG programming on the AS400 / iSeries
> Date: Tuesday, May 20, 2003 1:21:07 PM
> To: RPG programming on the AS400 / iSeries
> Subject: Re: AS400 to EXCEL
>
> I just found out a way this morning to not lose your leading zeros. It
> takes a little more work, but it does work.
>
> change the file extention (or create it that way) to .txt and open the
file
> from inside excel. it walks you through the import wizard - change to
> 'delimited', change the delimeter to ',' and on the next screen, change
the
> data type of the numbers from 'general' to 'text'.
>
> this will preserve your leading zeros. not optimal, but doable.
>
> Rick
> --------original message---------
> Booth,
>
> >Is this also true if the CSV fields are all enclosed in quotes? Not
> >apostrophes but quotation marks.
>
> In Excel, it still considers it a numeric value and drops the leading
zeros
> despite the presence of the quotation marks. Silly, but true.
>
> >"John Smith","001234"
>
> Not in Excel it doesn't. The second cell will be right-adjusted and the
> value
> displayed will be simply 1234. Even applying a cell format of "text" at
> that
> point will leave it as 1234 (albeit now left-justified). So the leading
> zeros
> are lost during the file open / import process.
>
> Doug
>
> _______________________________________________
> 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.
>
>