Clear Filters
Clear Filters

Filling an excel spreadsheet as I am calculating values simultaneously?

10 views (last 30 days)
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 Comments
Guillaume
Guillaume on 10 Dec 2019
"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 on 10 Dec 2019
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');

Sign in to comment.

Answers (1)

Roshni Garnayak
Roshni Garnayak on 13 Dec 2019
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!