how to call a column of data from excel into matlab

I need to take the mean median and mode from a column of data in excel
first i tried using fopen filename but i keep getting back -1
xlsread RealEstate.xls ??? Error using ==> xlsread at 214 XLSREAD unable to open file RealEstate.xls. File C:\Program Files\Dell\DellDock\RealEstate.xls not found.

 채택된 답변

Srinivas
Srinivas 2012년 5월 8일
yourdata = xlsread(your file name);
then you can process it
help mean
help xlsread
help importfile

댓글 수: 3

data = xlsread('RealEstate.xls')
??? Error using ==> xlsread at 214
XLSREAD unable to open file RealEstate.xls.
File C:\Program Files\Dell\DellDock\RealEstate.xls not fou
Where is your excel file located?
is 'RealEstate.xls' in the same folder, if not include path
yourdata = xlsread(your file name with complete path)

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

추가 답변 (0개)

카테고리

Community Treasure Hunt

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

Start Hunting!

Translated by