Using Matlab for excel data automation

조회 수: 2 (최근 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