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
inherently non-portable? | [reply] |
Yes- it requires OLE::Storage_Lite, as it says near the top of the README:
REQUIREMENT
This module requires these modules:
OLE::Storage_Lite
Jcode.pm (if you are using FmtJapan, or FmtJapan2)
Unicode::Map (if you are using FmtJapan2 or FmtUnicode)
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.
___
-DA
$_='daniel@coder.com 519-575-3733 /Prescient Code Solutions/ coder.c
+om
';s/-/ /g;s/([.@])/ $1/g;@y=(42*1476312054+7*3,14120504e4,-42*330261-3
+3,
42*5436+3,42*2886+10,42*434987+5);s/(.)/ord(uc($1))/ge;for(@x=split/32
+/;
@y; map{print chr} split /(..)/, shift(@x) + shift(@y)) {perlmonk.da.r
+u}
| [reply] [d/l] [select] |
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!!
| [reply] |
OMG thank you to whoever wrote this PM it just saved me COUNTLESS hours working on separate excel files and sheet within them. | [reply] |
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? | [reply] |
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).
___
-DA
$_='daniel@coder.com 519-575-3733 /Prescient Code Solutions/ coder.c
+om
';s/-/ /g;s/([.@])/ $1/g;@y=(42*1476312054+7*3,14120504e4,-42*330261-3
+3,
42*5436+3,42*2886+10,42*434987+5);s/(.)/ord(uc($1))/ge;for(@x=split/32
+/;
@y; map{print chr} split /(..)/, shift(@x) + shift(@y)) {perlmonk.da.r
+u}
| [reply] [d/l] [select] |