Saving data in a loop using xlswrite
显示 更早的评论
I am trying to use xslwrite to save data in a loop.
What I would like it to do is write the data in one row in Sheet1, then for i+1 write the data in the next row of Sheet1. I have tried to use the help, but I maybe was not understanding.
采纳的回答
Walter Roberson
2016-9-26
0 个投票
Doing that is very inefficient, especially if you are using R2015a or earlier. You would be better off doing one of the following:
- collect all of the data in a cell array, and then do a single xlswrite(); or
- if you are using MS Windows with Excel installed, use a COM object to connect to Excel and issue the updates more directly; there are ways to query the selection so you might not have to keep track yourself of how far you have written; or
- if you are using MS Windows with Excel installed and a version up to R2015a, use xlswrite1() from the File Exchange. You will need to keep track yourself of how far you have written
2 个评论
Walter Roberson
2016-9-27
Just before the loop, allocate a cell array column vector with as many entries as there are files to process. In the loop, instead of writing the data with xlswrite(), store the data in the next available slot in the cell array. After the loop, you can construct a single giant cell array by using vertcat(TheCell{:}) and it would be that array that you would xlswrite() all at the same time.
csvwrite() is only for numeric arrays.
However if it is acceptable to produce a .csv file instead of a spreadsheet, then you can use fopen() and fprintf() and finally fclose() to write the data.
Supposing you have a cell array C of mixed data type; for the purpose of illustration suppose the first column is string, the second is numeric decimal and the third is numeric floating point, then you can use something like
fmt = '%s,%d,%g\n';
Ct = C.';
fprintf(fid, fmt, Ct{:});
This illustrates two tricks: That you need to transpose the data before writing it, and that you need to use cell array expansion to create the arguments to fprintf() when you are writing out information of mixed data types.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
