Using Matlab for excel data automation

1 次查看（过去 30 天）
Shuvashish Roy
Shuvashish Roy 2019-10-19
回答： Prasad Parameswaran 2019-10-22
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.

请先登录，再回答此问题。

回答（1 个）

Prasad Parameswaran
Prasad Parameswaran 2019-10-22
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.

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by