textscan not reading file properly
조회 수: 1 (최근 30일)
이전 댓글 표시
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].
clear
fid=fopen('data.xlsx');
M = textscan(fid,'%n%n')
fclose(fid);
Any help is appreciated. Thanks!
댓글 수: 2
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 ?
답변 (2개)
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?
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!