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 comentario

Jan
Jan el 15 de Jun. de 2011
Is there a typo in "xlsread('Profiles.xls',:,1)"?

Iniciar sesión para comentar.

Respuestas (2)

Paulo Silva
Paulo Silva el 15 de Jun. de 2011

1 voto

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

1 comentario

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

Iniciar sesión para comentar.

ishwarya rameshbabu
ishwarya rameshbabu el 26 de Feb. de 2018

0 votos

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???????

Categorías

Más información sobre Environment and Settings en Centro de ayuda y File Exchange.

Etiquetas

Preguntada:

el 15 de Jun. de 2011

Respondida:

el 26 de Feb. de 2018

Community Treasure Hunt

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

Start Hunting!

Translated by