MATLAB Answers

How to batch processing the answers from MATLAB to Excel

1 view (last 30 days)
Hong Wei Tang
Hong Wei Tang on 19 Jun 2021
Edited: Prateek Rai on 29 Jul 2021
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!

Accepted Answer

Prateek Rai
Prateek Rai on 29 Jul 2021
Edited: Prateek Rai on 29 Jul 2021
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.

More Answers (0)

Tags

Products


Release

R2021a

Community Treasure Hunt

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

Start Hunting!