How to batch processing the answers from MATLAB to Excel

2 次查看（过去 30 天）
Hong Wei Tang
Hong Wei Tang 2021-6-19
编辑： Prateek Rai 2021-7-29
Greetings. I have several questions that i want to ask for you guys.
  1. How to import data from Excel? I used to utilise the function readmatrix() to read the data for particular column.
  2. How to use the data that I imported from Excel to perform batch processing? For instance, I've already imported years, months and days from Excel to MATLAB, now I need to perform calculations in MATLAB, and export every answers back to Excel after I got every answers by using formula.
  3. I think that the loop function would be involved in this case.
Here is a simple example:
I have many data in Excel:
Year Month Day
2001 1 1
2002 2 2
2003 3 3
I want to import these data above to MATLAB.
After that, I want to use these data to perform several calculation by using the formulas below:
Total=year+month+day
Something=Total-somethingelse
Once I get the answer which is 'something', I want to send back the result back to Excel. In this simple example, I will get 3 answers. I think the results will be shown like this below:
Something
2003
2006
2009
I think the loop function would be appeared in the coding. I have been searching this issue such a long time, please help me, and thanks for spending time to read and solve this question. Have a great day!

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

采纳的回答

Prateek Rai
Prateek Rai 2021-7-29
编辑：Prateek Rai 2021-7-29
To my understanding, you want to do the following tasks:
  • import data from excel sheet into MATLAB.
  • do some processing on imported data and export back to excel sheet.
  • wants to know if loop is involved or not.
(1) For importing data you can use readtable function.
For your example:
p = readtable("Simple Example.xlsx")
where Simple Example.xlsx is the name of example file.
(2) After importing data, you can use:
p.Total = p.Year + p.Month + p.Day
writetable(p,"Simple Example.xlsx")
(3) Using loop is not necessary here.
You can refer to readtable MathWorks documentation page to find more on readtable function and writetable MathWorks documentation page to find more on writetable function.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by