the modules i have installed are:
ParseExcel
SaveParser
Utility

(http://search.cpan.org/~szabgab/Spre...rseExcel-0.28/)

- d

-----
Donna Hofmeister, HP-CSA Sr. System Programmer
dgarverick -at- longs -dot- com
925-210-6631 Longs Drug Stores

>>>MY opinions, not Longs Drug Stores'<<<



----- Original Message ----
From: Robert Mills
To: HP3000-L@RAVEN.UTC.EDU
Sent: Thursday, March 8, 2007 2:10:29 AM
Subject: Re: [HP3000-L] Create a CSV file


Kellie,

I agree with donna on the perl part. Have been using the
Spreadsheet-WriteExcel module (find it at
http://search.cpan.org/dist/Spreadsheet-WriteExcel//) written by John
McNamara and have found it easy to do.

donna,

Exactly which module are you using to do the read?


regards,

Robert W.Mills
Systems Development Manager
Pinnacle Arvato
(020) 8309 3604


-----Original Message-----
From: HP-3000 Systems Discussion [mailto:HP3000-L@RAVEN.UTC.EDU] On
Behalf Of Donna Hofmeister
Sent: 07 March 2007 20:07
To: HP3000-L@RAVEN.UTC.EDU
Subject: Re: [HP3000-L] Create a CSV file

cobol will happily write to a bytestream file. no magic
required....just a fileequation.

the other suggested solutions will work...just write out toa bytestream
file.

if you're are of a perl-ish inclination....thereis a 'spreadsheet'
module that will read and write real .xls files...on mpe! (i've played
with the read portion of this module. it works file and i would expect
the write portion to work as well.)

there's no real need to ship (email/ftp/file transfer) your output file.
fire up samba and create a share. have your users map to this directory
and let them click-ity-click. - d

-----
Donna Hofmeister, HP-CSA Sr. System Programmer dgarverick -at- longs
-dot- com
925-210-6631 Longs Drug Stores

>>>MY opinions, not Longs Drug Stores'<<<



----- Original Message ----
From: kellie Jones
To: HP3000-L@RAVEN.UTC.EDU
Sent: Wednesday, March 7, 2007 9:53:27 AM
Subject: [HP3000-L] Create a CSV file


I've read the archives - and the only info I can find on CSV files is
converting to fixed from a csv file.

I was wondering if there was a way to create a *real* csv file on the
3000.

I don't have many resources - I can create a csv file with COBOL or with
QUIZ. What they really are is a fixed length file with commas in between
the fields. Problem is, if you open the file up in excel - there are
extra spaces, and it doesn't handle it correctly (you can see the data
fine - but if you need to load it into a database or do a lookup - it
includes the trailing spaces). I'd have to do a trim in excel and
re-savethe file to get rid of the spaces.

Is there a way to do this in COBOLor even just from the OS?

tia

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *



__________________________________________________ ______________________
____________
Get your own web address.
Have a HUGE year through Yahoo! Small Business.
http://smallbusiness.yahoo.com/domains/?p=BESTDEAL

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives,change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *



__________________________________________________ __________________________________
Don't pick lemons.
See all thenew 2007 cars at Yahoo! Autos.
http://autos.yahoo.com/new_cars.html

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *