MATLAB: Importing and calculation from excel to matlab

excelimporting excel dataMATLAB

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

Best Answer

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.

Related Solutions

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

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: How to rename a sheet in Excel using the COM interface in MATLAB

MATLAB: Error reading using xlsread

Related Question