MATLAB: How Can i import data from excel with column names

importimporting excel data

I am looking to import data from excel with colum names. I also meed to perform calculations for the whole column with that name.

For Example: Say i have a excel sheet with 50 columns of data. I want to pick a column from the dataset with the name of the column and do some mathematical operations on the whole column.

Best Answer

If you have R2013b or later then I recommend you use readtable() and then operate on the column by name.

Related Solutions

MATLAB: Importing and calculation from excel to matlab

you cannot use the column title directly.You have to use the index something like "Rawdata(16:end,3)".Which states that in Rawdata table 3rd column is "CO2_meas" and data is filled from the column no 16 .It is better if you attach the imported Rawdata file.So that more accurately we can specify the code.

MATLAB: Error reading using xlsread

[num,txt,Rawdata] = xlsread ('MAE 525 HW5 Soln.xlsx'); 
CO2_meas = num(16:end,2);
CO_meas = num(16:end,3);
result = CO2_meas.* CO_meas

Best Answer

Related Solutions

MATLAB: Importing and calculation from excel to matlab

MATLAB: Error reading using xlsread

Related Question