Using Matlab for excel data automation

3 visualizaciones (últimos 30 días)
Shuvashish Roy
Shuvashish Roy el 19 de Oct. de 2019
Respondida: Prasad Parameswaran el 22 de Oct. de 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.

Iniciar sesión para responder a esta pregunta.

Respuestas (1)

Prasad Parameswaran
Prasad Parameswaran el 22 de Oct. de 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.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by