importing and calculation from excel to matlab
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
sri satya ravi
el 12 de Abr. de 2016
Editada: Walter Roberson
el 13 de Abr. de 2016
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 comentarios
Respuesta aceptada
Stalin Samuel
el 12 de Abr. de 2016
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 comentarios
Stalin Samuel
el 13 de Abr. de 2016
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;
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!