calculate area in table
4 views (last 30 days)
Show older comments
nur afiqah
on 22 Jul 2019
Commented: Andrei Bobrov
on 23 Jul 2019
Greetings,
I have a 32 variables containing 1000++ rows and a column containing area for each row. Can Matlab read and call a certain variable in the row and calculate area based on selected variable?
0 Comments
Accepted Answer
Andrei Bobrov
on 22 Jul 2019
T = readtable('Book1.xlsx');
out = varfun(@sum,T,'g','Class_Name');
2 Comments
Andrei Bobrov
on 23 Jul 2019
T = readtable('Book2.xlsx');
out = varfun(@sum,T,'g',{'Class_Name','distance'});
More Answers (1)
KSSV
on 22 Jul 2019
Load the data from excel file using xlsread or readtable. Once you have data in workspace......you can get your desired result using some functions and indexing.
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!