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.

 Respuesta aceptada

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

3 comentarios

lowcalorie
lowcalorie el 8 de Mayo de 2012
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
Oleg Komarov
Oleg Komarov el 8 de Mayo de 2012
Where is your excel file located?
Srinivas
Srinivas el 9 de Mayo de 2012
is 'RealEstate.xls' in the same folder, if not include path
yourdata = xlsread(your file name with complete path)

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Data Import from MATLAB en Centro de ayuda y File Exchange.

Preguntada:

el 8 de Mayo de 2012

Community Treasure Hunt

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

Start Hunting!

Translated by