Invalid or Empty Spreadsheet error ?
3 views (last 30 days)
Show older comments
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 Comments
Image Analyst
on 23 Sep 2014
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?
Answers (1)
Star Strider
on 20 Sep 2014
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 Comments
Guillaume
on 23 Sep 2014
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
on 23 Sep 2014
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.
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!