Invalid or Empty Spreadsheet error ?
显示 更早的评论
Greetings everyone,
I am beginner in Matlab and currently using Matlab R2013a.
I need to import a excel file into Matlab. So, I use the Import Data button and select the file I want to import. But in Matlab, a message appears that "the spreadsheet is invalid or empty" !!! And there is surely data present in the spreadsheet. I really don't know how to resolve this. Need help ASAP !!!
Regards, Abhik Das
3 个评论
Image Analyst
2014-9-19
Can you attach your workbook so we can try it ourselves?
Abhik Das
2014-9-20
Image Analyst
2014-9-23
That's not an Excel workbook, it's a simple text file. How did you try to read it in? With xlsread()? Or some other function?
回答（1 个）
Star Strider
2014-9-20
Use testscan. It will read it without problems:
fidi = fopen('S17_R1.xls');
D = textscan(fidi, '%f %f', 'HeaderLines',2);
produces ‘D’ as a (1x2) cell:
D =
[502x1 double] [502x1 double]
5 个评论
Abhik Das
2014-9-22
Star Strider
2014-9-22
What error do you get?
It worked for me with your file and with the code I posted.
Abhik Das
2014-9-23
Guillaume
2014-9-23
Most likely, fidi equal -1, meaning the file was not found. Check the filename, and that the file is in the current matlab folder.
Star Strider
2014-9-23
Be sure the file is either in your MATLAB user folder (or somewhere in the MATLAB search path), or that you provide the full path to the file.
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
2014-9-23
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
