the modules i have installed are:
ParseExcel
SaveParser
Utility
(http://search.cpan.org/~szabgab/Spreadsheet-ParseExcel-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 <[log in to unmask]>
To: [log in to unmask]
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:[log in to unmask]] On
Behalf Of Donna Hofmeister
Sent: 07 March 2007 20:07
To: [log in to unmask]
Subject: Re: [HP3000-L] Create a CSV file
cobol will happily write to a bytestream file. no magic
required....just a file equation.
the other suggested solutions will work...just write out to a bytestream
file.
if you're are of a perl-ish inclination....there is 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 <[log in to unmask]>
To: [log in to unmask]
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-save the file to get rid of the spaces.
Is there a way to do this in COBOL or 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 the new 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 *
|
