xlsread unable to find .xls file

I'm using a computer that's new to me with a different version of Matlab than I'm used to - R2006a. I've written a simple script that uses the xlsread command to call to an .xls file named "Profiles.xls" using the following diction:
xk = xlsread('Profiles.xls',:,1);
When I attempt to run the script, I receive the following error...:
??? XLSREAD unable to open file Profiles.xls.
Error using ==> iofun\private\validpath
File C:\Profile Development\Profiles.xls not found.
...The .xls is in the indicated folder, which I'm also using as the active folder in Matlab.
I don't have the experience to interpret what is happening in the validpath script, although it is where it should be and it doesn't have anything obviously wrong with it.

댓글 수: 1

Jan
Jan 2011년 6월 15일
Is there a typo in "xlsread('Profiles.xls',:,1)"?

댓글을 달려면 로그인하십시오.

답변 (2개)

Paulo Silva
Paulo Silva 2011년 6월 15일

1 개 추천

I wonder if the file extension is xlsx, check that out and also try this:
xk = xlsread('Profiles')

댓글 수: 1

Brad
Brad 2011년 6월 15일
Bingo. Never mix versions of Microsoft software. Although for future reference, xk = xlsread('Profiles.xlsx') works, while xk = xlsread('Profiles') does not.

댓글을 달려면 로그인하십시오.

ishwarya rameshbabu
ishwarya rameshbabu 2018년 2월 26일

0 개 추천

Error using xlsread (line 128) XLSREAD unable to open file '../data/input.csv'. File 'D:\Program Files\MATLAB\MATLAB Production Server\R2014a\data\input.csv' not found.
Error in traffic_ann (line 4) input_data = xlsread('../data/input.csv'); while executing im getting this kind of errors???????

카테고리

도움말 센터File Exchange에서 Environment and Settings에 대해 자세히 알아보기

태그

질문:

2011년 6월 15일

답변:

2018년 2월 26일

Community Treasure Hunt

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

Start Hunting!

Translated by