I found difficulties when importing Excel spreadsheet edited in MS Office Excel 2007. It’s probably bug case in which edited spreadsheet isn’t compatible with import function. Actually the solution I have found is based on editing/exporting XLS spreadsheet via Open Office. Works fine when using OO Calc.
Let me know if you’d like to get testing files (from OO Calc and MS Excel '07).
Regards, Peter