Spool file to Excel?

Koldark

unread,

Feb 22, 2001, 10:39:24 PM2/22/01

to

I am not sure if this has been asked before, I just joined today.

I am trying to figure out if there is a way to get a spool file into M$
Excel (either into Excel format or comma separated values). I am trying to
do this with out purchased software. One of my co-workers stated that she
saw this at COMMON, but we can't find the information anywhere. What it did
was assign a function key to output report directly into Excel. (Or
something like that). What we are trying to do is find a user friendly way
of doing this. Even if this isn't possible, if anyone knows of an easy way
to import into Excel, I would welcome the suggestions.

BTW - This is a report with numerous calculations in the background. And we
would like a solution that would work for many different reports, not just
one.

---
Mike Wills
mnw...@koldark.net
mnw...@taylorcorp.com

"Unix + Macintosh = Nirvana" - Steve Jobs

Bert de Vries

unread,

Feb 23, 2001, 8:47:28 AM2/23/01

to

In the december 2000 issue of NEWS/400 is tip about this.
In short:
first:
CPYTOIMPF FROMFILE(<library>/<file>) TOSTMF(<stream file1>)
RCDDLM(*CRLF) STRDLM('"') FLDDLM(',')

next:
COPY OBJ(<stream file1>) TOOBJ(<stream file2>) TOCODEPAGE(*PCASCII)
DATAFMT(*TEXT)

where <stream file1> stands for QDLS/<folder>/<file.TXT>
and <stream file2> stands for QDLS/<folder>/<file.CSV>

This way you wil have a CSV file which can be read by excell (Comma
Seperated Values)

hope this helps

--
Met vriendelijke groeten,
Bert de Vries
bdevri...@rbk.nl
Pobody is Nerfect ;-)
Koldark <junk...@koldark.net> schreef in berichtnieuws
MTkl6.10588$53.11...@cletus.bright.net...

James Durr

unread,

Feb 23, 2001, 9:03:48 AM2/23/01

to

Hello,

My company sells an AS/400 command that can convert a spooled file into
an Excel(.xls) file. Check out our website at http://www.kemetech.com

James

--
James Durr
Technical Consultant
KemeTECH Systems Inc.
103 Vassar Avenue, Newark, NJ 07112-2249
Phone( 973) 923-2328 e-fax (978-231-5825)
jd...@kemetech.com

BAK

unread,

Feb 23, 2001, 9:21:03 PM2/23/01

to

James:

Does your company offer a trial version of the program?
Cause It is really hard for someone to see how it will work etc.

thanks

BAK

"James Durr" <jd...@kemetech.com> wrote in message
news:3A966D52...@kemetech.com...

James Durr

unread,

Feb 24, 2001, 1:30:46 PM2/24/01

to

Hi Bak,

Sure trial versions are available. Just visit our site
http://www.kemetech.com and click downloads, complete the form and
you will receive a trial copy.

James

Koldark

unread,

Feb 24, 2001, 4:50:36 PM2/24/01

to

Think this might work...I will have to try it on Monday...

between this and a couple other things I have found, I think I can get
something going now.

--
---
Mike Wills
mnw...@koldark.net

"Unix + Macintosh = Nirvana" - Steve Jobs

"Bert de Vries" <bdevri...@rbk.nl> wrote in message
news:982935960.4641....@news.demon.nl...

QSECOFR

unread,

Feb 24, 2001, 11:45:28 PM2/24/01

to

What about CPYTOPCD lib/obj/member QDLS/foldername/filename

"Koldark" <junk...@koldark.net> wrote in message
news:MTkl6.10588$53.11...@cletus.bright.net...