Spreadsheet-ParseExcel miscs

rgpm has asked for the wisdom of the Perl Monks concerning the following question:

hi, after having some investigations i got stuck here.

1.) i need to parse excel files, which could be saved as MS Excel 95/97, 2000, XP or possibly 2003. does the Spreadsheet-ParseExcel support all of those versions?
2.) there are 9 checkboxes in, which do not display their value into a cell. am i able to access these checkbox objects? i guess not...
3.) stupid question: if there is a file attached to a page, like a picture, or visio, is it possible to extract this data to the hard disk? i even did not manage this using MS VB...
4.) i've read that the parser consumes a lot of memory. if a excel file is around 8-9 mb due to file attachments (pics, net plans) and the data grabed from the file is something like 1000 fields, the processing should not use to much, is it like this?
Is the parser parsing fast?

many thanks for any help.
cheers,
ralf

Comment on Spreadsheet-ParseExcel miscs

Replies are listed 'Best First'.
Re: Spreadsheet-ParseExcel miscs by jmcnamara (Monsignor) on Sep 17, 2004 at 13:09 UTC
1. Spreadsheet-ParseExcel supports all of those formats. 2. You cannot access the checkbox values. * 3. You cannot extract embedded objects. * 4. It is correct that the memory consumption is a function of the amount of cell data and not of the actual file size. See also: Reducing the memory usage of Spreadsheet::ParseExcel. * While it isn't possible to do this using Spreadsheet::ParseExcel it is theoretically possible to do it via OLE-Storage_Lite. It would require a lot of work however. -- John.	[reply]
Re: Spreadsheet-ParseExcel miscs by davidj (Priest) on Sep 17, 2004 at 09:58 UTC
several of your questions could be answered by reading the documentation, `perldoc SpreadSheet::ParseExcel`. Maybe you should give that a try. davidj	[reply] [d/l]