amcho blog

Have just spent the last couple of days trying to process a spreadsheet file created in openoffice using perl. The problem I had was deciding which CPAN module to use. A choice of one which did everything I wanted would have been ideal. Unfortunately I had the overwhelming choice of hundreds.

I finally settled for ODF::lpOD

Thanks to the following pages that pointed me in the right direction:
how-to.wikia.com/wiki/How_to_read_OpenOffice_OpenDocument_spreadsheets_in_Perl

search.cpan.org/dist/ODF-lpOD/lpOD/Tutorial.pod#Individual_cell_access,_read_and_update

search.cpan.org/~jmgdoc/ODF-lpOD-1.114/lpOD/Table.pod

Busy updating websites so they work in PHP 5.3
a somewhat boring task:
change each MySQL login password so it is stored in the new format
and update any depreciated code:
replace split with preg_split
replace ereg with preg_match
and wait for them to come to term!
Or postpone the problem till PHP 6 by ignoring all depreciated warnings:
error_reporting(E_ALL & ~E_NOTICE & ~E_DEPRECATED);
and do the job properly later…

Links:
PHP 5.3 depreciated functions
error-reporting