On Friday 04 Dec 2009 12:15:58 Rene Schickbauer wrote: > Xiao Lan (小兰) wrote: > > On Fri, Dec 4, 2009 at 3:40 PM, Parag Kalra <paragka...@gmail.com> wrote: > >> Hello All, > >> > >> I am looking for some good Perl modules to process excel sheets. > > > > Hi, > > > > If you just want a module, take a look at this one (I once used it): > > > > http://search.cpan.org/~jmcnamara/Spreadsheet-ParseExcel-0.55/lib/Spreads > >heet/ParseExcel.pm > > Depending on the Excel version used to generate the files and the actual > filetype saved (OOXML anyone?), this might or might not work. > > If in doubt, you could use Win32::OLE (on a windows machine) to convert > the file to a CSV-File (comma seperated values) first, take a look here: > > http://www.ngbdigital.com/perl_ole_excel.html > > Then you could use a number of CPAN modules to process the CSV. One of > the more exotic one is DBD::CSV, where use can use the file like a > database table ;-) >
And another option that may work better than the Spreadsheet-ParseExcel one but probably not as well as the OLE solution would be to utilise OpenOffice.org to read the file and then save it in an easier-to-digest format (such as CSV or OpenDocument). It's possible OpenOffice.org may be able to handle more diverse Excel files than the CPAN module. Regarding using OLE - if you're not running Windows, you can still make use of it to convert the XML into shape by running a network service of some sort on top of a different Windows machine or a virtual machine (see http://www.virtualbox.org/ for example). Regards, Shlomi Fish > LG > rene > -- ----------------------------------------------------------------- Shlomi Fish http://www.shlomifish.org/ Freecell Solver - http://fc-solve.berlios.de/ Chuck Norris read the entire English Wikipedia in 24 hours. Twice. -- To unsubscribe, e-mail: beginners-unsubscr...@perl.org For additional commands, e-mail: beginners-h...@perl.org http://learn.perl.org/
