importing and calculation from excel to matlab
4 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
sri satya ravi
il 12 Apr 2016
Modificato: Walter Roberson
il 13 Apr 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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/160961/image.png)
i am working on and having an issue. Please let me know if there is a way to do those kind of calculations
0 Commenti
Risposta accettata
Stalin Samuel
il 12 Apr 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 Commenti
Stalin Samuel
il 13 Apr 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;
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!