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.

 Akzeptierte Antwort

Srinivas
Srinivas am 8 Mai 2012
yourdata = xlsread(your file name);
then you can process it
help mean
help xlsread
help importfile

3 Kommentare

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)

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Community Treasure Hunt

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

Start Hunting!

Translated by