For the most part, Spreadsheet::ParseExcel will read those files. There is a known caveat about formulas, but that's well-documented.
My criteria for good software:
- Does it work?
- Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
| [reply] |
Will Spreadsheet::ParseExcel allow me to add data to the XLS file and then save? Here is my story so far: I wrote a Perl program to create and add data to a XLS spreadsheet using WIN32OLE. My company, now, will not let me install Excel on the server. So I now need to recreate the script so as not to use the actual Excel application. So I need to find a way to open, add data, and then save the XLS spreadsheet using Perl.
| [reply] |
There is currently no one-stop solution that provides reading and writing of Excel files without Win32::OLE. Putting one together with both WriteExcel and ParseExcel shouldn't be too hard. If you want some help, I'd be glad to give some advice. A solution using tie and DBM::Deep for the data structures might be kinda cool.
My criteria for good software:
- Does it work?
- Can someone else come in, make a change, and be reasonably certain no bugs were introduced?
| [reply] |
| [reply] |
| [reply] |
I like Spreadsheet::TieExcel for reading and writing Excel files, but it only works on Windows with Excel installed.
Cheers,
Brent
| [reply] |
If your company does not allow you to install Excel, can you install Open Office? Open Office can read in Excel files and save them in its own format, which you can then manipulate with modules such as OpenOffice::OOBuilder, OpenOffice::OOSheets or OpenOffice::Parse::SXC.
CountZero A program should be light and agile, its subroutines connected like a string of pearls. The spirit and intent of the program should be retained throughout. There should be neither too little or too much, neither needless loops nor useless variables, neither lack of structure nor overwhelming rigidity." - The Tao of Programming, 4.1 - Geoffrey James
| [reply] |