清空筛选条件
清空筛选条件

textscan not reading file properly

1 次查看（过去 30 天）
Benson
Benson 2013-7-1
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!
  2 个评论
Walter Roberson
Walter Roberson 2013-7-2
Which MATLAB release are you using, and which operating system? If you are on MS Windows, which version of Excel do you have installed ?
per isakson
per isakson 2013-7-2
textscan cannot read an xlsx-file. It isn't text.

请先登录，再进行评论。

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

回答（2 个）

Azzi Abdelmalek
Azzi Abdelmalek 2013-7-1
M=xlsread('data.xlsx');
  2 个评论
Benson
Benson 2013-7-1
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.
per isakson
per isakson 2013-7-2
Open and close the file with Excel.

请先登录，再进行评论。

per isakson
per isakson 2013-7-2
编辑：per isakson 2013-7-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?

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by