importing and calculation from excel to matlab

Question

sri satya ravi 2016-4-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/278637-importing-and-calculation-from-excel-to-matlab

编辑： Walter Roberson 2016-4-13

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.

I am attaching an image of the data-set and the matlab function

i am working on and having an issue. Please let me know if there is a way to do those kind of calculations

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stalin Samuel 2016-4-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/278637-importing-and-calculation-from-excel-to-matlab#answer_217590

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.

2 个评论
显示无隐藏无

sri satya ravi 2016-4-12

MAE 525 HW5 Soln.xlsx

Hi, I am attaching the rawdata excel file.....please have a look and let me know

Stalin Samuel 2016-4-13

在 MATLAB Online 中打开

filename = 'MAE 525 HW5 Soln.xlsx';
sheet = 1;
xlRange = 'C17:C12006';
CO2_meas = xlsread(filename,sheet,xlRange);
xlRange1 = 'D17:D12006';
CO_meas = xlsread(filename,sheet,xlRange1);
X = CO2_meas.*CO_meas;