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 Comment

Is there a typo in "xlsread('Profiles.xls',:,1)"?

Sign in to comment.

Answers (2)

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

1 Comment

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

Sign in to comment.

ishwarya rameshbabu
ishwarya rameshbabu on 26 Feb 2018
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???????

Tags

Asked:

on 15 Jun 2011

Community Treasure Hunt

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

Start Hunting!