You are here:

CAD/import Excel data to Matlab

Advertisement


Question
"Hello Sir

I want to know how can I import one numerical Excel 2007 data sheet to Matlab 2007b.I have tried xlsread order in Matlab space but it warns:



A = xlsread('w5data.xls')

??? XLSREAD unable to open file w5data.xls.

Error using ==> iofunprivatevalidpath

File C:Program FilesMATLAB71workwell15data.xls not found.


Thank you."

Answer
Hi javad,

this error is a path error. The command you issue (xlsread('w5data.xls')) implies that the file  w5data.xls is in the current directory, which drom what i can tell is the default 'work' directory under the matlab root folder. Either provide a full path to the file you want to read e.g. A = xlsread('C:\path_to_file\w5data.xls') or just copy the file to the 'work' folder.

Best
G.

CAD

All Answers


Answers by Expert:


Ask Experts

Volunteer


George Moustris

Expertise

I have extensive experience in MATLAB which is a CAD for engineers.I can answer many questions on the programming script as well as the use of many toolboxes Matlab uses.However DO NOT ask me about the underlying theory of your projects.I will only answer questions regarding the USE of Matlab.

Experience

I have written many scripts in Matlab utilizing many toolboxes and libraries such as Fuzzy Logic toolbox,Neural Nets,Image processing,Wavelets,Signal processing etc.

Organizations
Aristotle University of Thessaloniki

©2012 About.com, a part of The New York Times Company. All rights reserved.