Re: write to an Excel document
Hello Allison, To write an excel file you will need John McNamara's module Spreadsheet::WriteExcel. You can read on the CPAN documentation at http://search.cpan.org/search?dist=Spreadsheet-WriteExcel To read an excel file and write output as textfile you will need Kawai Takanori's module Spread::ParseExcel. You can read on the CPAN documentation at http://search.cpan.org/search?dist=Spreadsheet-ParseExcel The two modules depend on other perl modules. These are: ParseRecDescent IO-Stringy OLE-Storage_Lite Text-Balanced If you execute your script using the excel modules and find error such as ParseRecDescent.pm not found, then visit CPAN and download it. In any case, there is ample documentation and examples on how to use the modules. Good luck. Alfred Vahau Project Breeze Coordinator School of Natural and Physical Sciences University of Papua New Guinea Papua New Guinea -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: write to an Excel document
The link is at: http://www-106.ibm.com/developerworks/linux/library/l-pexcel/ (l not I) "Tirthankar C. Patnaik" wrote: > > An excellent link for the task you have in mind, is: > > http://www-106..ibm.com/developerworks/linux/library/I-pexcel/ -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: write to an Excel document
(This is one of those topics that should be in the FAQ). Have you considered dumping your data into a CSV file with a CSV extension? Excel will open CSVs by default. It's the *easiest* way, but may not be what you want... -rjf > -Original Message- > From: Allison Ogle [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, March 12, 2002 11:19 > To: [EMAIL PROTECTED] > Subject: write to an Excel document > > > Hi > > Does anyone know how to write to an Excel document? I've > opened the document using OLE but I cannot find any > documentation on how to store data in the spreadsheet. If > anyone knows what the commands are to do this please let me > know. Thanks, > > Allison > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: write to an Excel document
Take a look at Spreadsheet::WriteExcel on CPAN (www.cpan.org). On Tue, 2002-03-12 at 12:18, Allison Ogle wrote: > Hi > > Does anyone know how to write to an Excel document? I've opened the > document using OLE but I cannot find any documentation on how to store data > in the spreadsheet. If anyone knows what the commands are to do this please > let me know. Thanks, > > Allison > > > -- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] -- Today is Sweetmorn the 71st day of Chaos in the YOLD 3168 Pzat! Missile Address: 33:48:3.521N 84:23:34.786W -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: write to an Excel document
Dear Allison, > Does anyone know how to write to an Excel document? I've opened the > document using OLE but I cannot find any documentation on how to store data > in the spreadsheet. If anyone knows what the commands are to do this please > let me know. Thanks, > Try the SpreadSheet::ParseExcel, and the SpreadSheet::WriteExcel modules from CPAN. An excellent link for the task you have in mind, is: http://www-106..ibm.com/developerworks/linux/library/I-pexcel/ HTH, -tir -- Tirthankar, IGIDR. +91-22-8400919 x275 (r), x593(o), x542(CFL). http://www.igidr.ac.in/~tir MEDICINE, n. A stone flung down the Bowery to kill a dog in Broadway. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: write to an Excel document
Check out Spreadsheet-WriteExcel available at www.cpan.org. Really great module for creating Excel spreadsheets. Craig A. Sharp Unix Systems Administrator DNS Administrator Roush Industries Office: 734-466-6286 Cell: 734-231-6769 Fax: 734-466-6939 [EMAIL PROTECTED] I have not lost my mind, it's backed up on tape somewhere! >>> "Allison Ogle" <[EMAIL PROTECTED]> 03/12/02 12:18PM >>> Hi Does anyone know how to write to an Excel document? I've opened the document using OLE but I cannot find any documentation on how to store data in the spreadsheet. If anyone knows what the commands are to do this please let me know. Thanks, Allison -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
write to an Excel document
Hi Does anyone know how to write to an Excel document? I've opened the document using OLE but I cannot find any documentation on how to store data in the spreadsheet. If anyone knows what the commands are to do this please let me know. Thanks, Allison -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]