Using Matlab for excel data automation

2 vues (au cours des 30 derniers jours)
Shuvashish Roy
Shuvashish Roy le 19 Oct 2019
Réponse apportée : Prasad Parameswaran le 22 Oct 2019
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 commentaire
darova
darova le 19 Oct 2019
Show your attempts

Connectez-vous pour commenter.

Connectez-vous pour répondre à cette question.

Réponses (1)

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

Catégories

En savoir plus sur Spreadsheets dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by