Greetings. I have several questions that i want to ask for you guys.
- How to import data from Excel? I used to utilise the function readmatrix() to read the data for particular column.
- 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.
- 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:
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:
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!