Filling an excel spreadsheet as I am calculating values simultaneously?

19 次查看(过去 30 天)
I need help finding a way to fill up an excel sheet from calculation gradually as my function continues producing values from different loops. Is that possible?
  6 个评论
Guillaume
Guillaume 2019-12-10
"I though there were a function that would fill row by row with the information my arrays were getting from the calculations"
writematrix and co. will put whatever you want exactly where you tell it to. It won't take a guess at what else you want to put somewhere else. If you tell writematrix to put some data in a row, it'll put it in that row, so yes you can fill a file row by row. Note that it's not the most efficient way to go about, writing everything at once would make more sense), but it's certainly possible.
"The issue is my array that is filling up Columns A, B and C, it is always smaller than the rest."
So far, it doesn't appear that you write anything in column A, B, C, so nothing is going to end up there.
Lazaro Gonzalez
Lazaro Gonzalez 2019-12-10
Yes, I do, sorry I didn't paste my code for those columns
writematrix(FL2(:,1),'DataM.xls','Range','A3');
writematrix(FL3(:,1),'DataM.xls','Range','B3');
writematrix(FL4(:,1),'DataM.xls','Range','C3');

请先登录,再进行评论。

回答(1 个)

Roshni Garnayak
Roshni Garnayak 2019-12-13
You can refer to the following link for writing data to Excel Spreadsheets:https://www.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html

Community Treasure Hunt

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

Start Hunting!

Translated by