I tried installing Spreadsheet::ParseExcel from CPAN on my linux box
and it did not install. The place where it failed made me
think I should try installing the OLE module from CPAN first,
and that failed as well.
I haven't checked the usenet news groups about this yet,
and there was nothing in the README file about it,
but is it just stupid to attempt this? Is Spreadsheet::ParseExcel
I installed both of these using the CPAN module, which is quite useful if you haven't seen it. The CPAN process automates installation nicely; it asks if you want to fulfill unmet dependencies and install OLE::Storage_Lite. I said yes, it installed OK, and I re-ran 'install Spreadsheet::ParseExcel' with no problems.
There could be further dependencies you'd need to install for OLE::Storage_Lite to work; but it's much easier with the CPAN module.
Thank you. Yes, I always use CPAN. (Pretty soon I'll never
be able to do it any other way!)
Turns out that OLE::Storage_Lite also required IO::Scalar,
which I didn't have yet, but once that was in, everything
went smoothly. Reading excel spreadsheets from my linux
partition will save me a ton of grief!!
I am trying to read an Excel spreadsheet and then input the data into an ora db, all on solaris. When using the Spreadsheet::ParseExcel to get the data from the spreadsheet, I am having trouble extracting the data from cells that are formatted as 'Date'. I have done the conversion to text on win32 using variants, but those packages are only for win32. Does anyone know what methods in Spreadsheet::ParseExcel I need to use to extract as text a value from a cell that is set to be a 'Date' in the excel spreadsheet?
As far as I know, you just use Value. What exactly does it output for date cells? When I just ran the above sample code on a linux box, I got a formatted date output where there is a date in the original data (an Excel 2000-formatted spreadsheet).