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 件のコメント
darova
darova 2019 年 10 月 19 日
Show your attempts

サインインしてコメントする。

サインインしてこの質問に回答する。

回答 (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