Error to .xls and .ods import

I have the same problem, read about PHP memory limit and max time limit expanding but I couldn't do it.
http://drupal.org/node/1183412 this post seens to show other solution, but i couldn't understand it too.

Thanks.

Is this for a specific XLS or for all of them?

Hi.

This looks like the paths for the libraries are not defined.

Hi I also have this error when attempting to import ods file -

Exception: Serialization of 'SimpleXMLElement' is not allowed in serialize() (line 110 of /var/www/html/drupal-7.22/sites/all/modules/sheetnode/modules/sheetnode_phpexcel/sheetnode_phpexcel.import.inc).

Refers here:
function _sheetnode_phpexcel_batch_import_file($filename, $filepath, $callback, $params, &$context) {
module_load_include('inc', 'node', 'node.pages');
set_time_limit(0);
global $user;

if (empty($context['sandbox']['workbook'])) {
// Load workbook and get number of worksheets.
$workbook = PHPExcel_IOFactory::load($filepath);
$context['sandbox']['workbook'] = serialize($workbook);
$context['sandbox']['total'] = $workbook->getSheetCount();
$context['sandbox']['current'] = 0;
$context['sandbox']['filename'] = $filename;
}

For the record, I am able to import xls files (although with formula errors, but that is another issue...)
As you can no doubt tell, I have no idea where to go from here. Thanks for the module which is not quite usable for me so far, but I am hopeful...

Here is it, infojunkie, and thanks for your help - the file attached worked fine as an xls file but when saved as ods and imported generated the error msg above.
(editing comments behaving strangely here today)

ancym, can you please attach the offending .ods file here? I am unable to reproduce this.

Thanks, this file shows the error for me too :-)

I found the problem to originate from the PHPExcel library, which keeps some document properties in XML format instead of converting them to plain text. I need to think about the best approach to fix this: handle it in Sheetnode or submit a patch to PHPExcel? Will update this thread.

Use summary template

Submitted pull request to PHPExcel library. Will also try to find a way to guard against errors on the Sheetnode side.

Pull request to PHPExcel was accepted and merged into their develop branch. Although it may be a while until the new official PHPExcel version features this fix, marking this issue as fixed.

No change in this module.