How Can i import data from excel with column names

48 views (last 30 days)
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.

Accepted Answer

Walter Roberson
Walter Roberson on 11 Apr 2016
If you have R2013b or later then I recommend you use readtable() and then operate on the column by name.
  5 Comments
Walter Roberson
Walter Roberson on 13 Apr 2016
t = readtable('MAE 525 HW5 Soln.xlsx', 'Range', 'B15:V12006');
t.Properties.VariableNames
CO2_meas = str2double(t.CO2_meas(2:end));
Your data turns out to have a 14 irrelevant lines at the top that needed to be skipped over. Unfortunately readtable() does not support the HeaderLines option for spreadsheets in the release I have (R2014a), but the change in documentation for R2014b suggests that for that version onward you might possibly be able to use
t = readtable('MAE 525 HW5 Soln.xlsx', 'HeaderLines', 14);
You might notice I have used str2double on the data. That is because you have a second header below the row name that gives the units, and that text field is being interpreted by readtable as indicating that the entire column should be treated as text. :(

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!