Using Matlab for excel data automation

Hi, I have some data in the attached input excel file. it is only a portion of large table. I will have to get the attached output table from the input table. The percentage data is calculated by %= (area value/totals)*100

I need to add this % value with their respective cells. I highly appreciate your help. Thanks.

[darova]

Show your attempts

Answer 1

[Prasad Parameswaran]

Here is one way of solving the problem.

• Read the input table to MATLAB using "readtable()" command. For more information refer this link.
• Do percentage data calculations in MATLAB.
• Export the output to .xlsx file using "writetable(table,filename)". For more information on writetable refer this link.