textscan not reading file properly

I have used textscan successfully in this manner for other files (different file extension). I am not sure why it does not work for this excel sheet (.xlsx). It is telling me that M = [0x1 double] [0x1 double].

http://img14.imageshack.us/img14/4594/b830.png

clear
fid=fopen('data.xlsx');
M = textscan(fid,'%n%n')
fclose(fid);

Any help is appreciated. Thanks!

Which MATLAB release are you using, and which operating system? If you are on MS Windows, which version of Excel do you have installed ?

textscan cannot read an xlsx-file. It isn't text.

Answer 1

M=xlsread('data.xlsx');

I have tried that, but I get "Unable to read XLS file C:\Users\Benson\Desktop\Princeton13 Documents\ECData\data.xlsx. File is not in recognized format."

I have also tried editing the file extension to data.xls, but I get the same error.

Open and close the file with Excel.

Answer 2

Could it be that the cells in Excel are defined as right-justified text? Try

    [num,txt,raw] = xlsread('data.xlsx')

and inspect all three outputs.

Which versions of Excel and Matlab do you use?