I have one more question related to the module - 'Spreadsheet-ParseExcel' I want to extract the default header names of the excel sheet.
So basically I am looking for a method to extract the column names whose default values are 'A', 'B', 'C', 'D' etc. Thus I am looking for a function which would return list of all the column names. By default it would return A, B, C so and so forth. Or it will return the column names that are actually set. I hope I am clear on this. :) Cheers, Parag 2009/12/4 Shlomi Fish <shlo...@iglu.org.il> > 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<http://search.cpan.org/%7Ejmcnamara/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. >
