Problem to import data from Excel to Matlab

1 次查看（过去 30 天）

显示更早的评论

Maddalena Mandarà 2011-6-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/9216-problem-to-import-data-from-excel-to-matlab

采纳的回答： Kaustubha Govind

Hello, I've a problem to import data from excel file to Matlab. I'm using xlsread function in the following way:

[num,text]=xlsread('myxlsfile.xls')

then I receive this warning message:

"Warning: XLS File contains unrecognized string header - skipping remaining text - (1027:0x20 57307)"

and the 'text' matrix result truncate. I've tried to copy and paste the data in an other xls file, but the problem persist. My xls file is approximately 20MB.

Is it too large? Could anyone help me?

Thank you

Maddalena

6 个评论
显示 4更早的评论隐藏 4更早的评论

Image Analyst 2011-6-12

Well there's your problem - you installed Excel 2011 on your Windows 7 computer. I didn't even know you could do that since that's a Apple Macintosh product. The latest Excel for Windows is 2010, while for the Macintosh it's 2011. Try installing Office 2010 for Windows instead. ;-)

Can you open that file in any version of Excel on any platform? It seems if it's a corrupt workbook with a corrupt header that even Excel wouldn't open it.

Maddalena Mandarà 2011-6-12

Sorry, I've type Excel 2011 instead of Excel 2010. Anyway I tried to open my file on Excel 2008 on Macintosh system on an other platform, and there wasn't problem.

Unfortunately, my xls file contains numeric and text data, then I can not save it as a binary file and import it as a text file.

I've just try to import a selected range of my xls file, then I've type the command: [num,text]=xlsread('myxlsfile.xls','a1:bv5000') but the warning on 'unrecognized string header' appears. I've use this range because Matlab detective the problem at the row 4813 of the "text" matrix. Then

I've try to type the command: [num,text]=xlsread('myxlsfile.xls','a1:bv50') where the range don't include the row 4813.

The warning message persist because Matbal tell me that "Range cannot be used in 'basic' mode. The entire sheet will be loaded. ' Thank you for your help! Maddalena

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Kaustubha Govind 2011-6-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/9216-problem-to-import-data-from-excel-to-matlab#answer_12822

在 MATLAB Online 中打开

On Windows machine, MATLAB opens Excel as a COM server to read data from Excel files. On other platforms, xlsread operates in what is called a 'basic' mode, which doesn't support some file formats. From the warning message that you receive: "Range cannot be used in 'basic' mode. The entire sheet will be loaded.", it seems that MATLAB is somehow unable to start-up Excel as a COM server. So the best path of resolution to your issue is to first resolve any errors occurring while starting Excel as a COM server.

Try executing the following command to see if you receive an error:

e = actxserver('Excel.Application')

11 个评论
显示 9更早的评论隐藏 9更早的评论

Maddalena Mandarà 2011-7-15

I solved the problem with the help of MathWorks Technical Support. I used an Excel's vitualized version and this was the gap. Now, I use an Excel's application version and xlsread work very well.

Thank you to all

Maddalena