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.

 Réponse acceptée

yourdata = xlsread(your file name);
then you can process it
help mean
help xlsread
help importfile

3 commentaires

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)

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

Community Treasure Hunt

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

Start Hunting!

Translated by