Invalid or Empty Spreadsheet error ?

3 views (last 30 days)
Abhik Das
Abhik Das on 19 Sep 2014
Commented: Star Strider on 23 Sep 2014
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
Abhik Das
Abhik Das on 20 Sep 2014
Oh sure, I am attaching the file here :
Image Analyst
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?

Sign in to comment.

Answers (1)

Star Strider
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
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
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.

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!