Why `WriteMode` isn't working while appending data to xlsx?
16 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Deepa Maheshvare
am 20 Mai 2020
Bearbeitet: Anthony Phipps
am 18 Okt. 2020
I'm doing the following
excelFilename = 'someFile.xlsx';
structFieldnames = fieldnames(myStruct); % <--- where myStruct is your struct of data
for k = 1:length(structFieldnames)
fieldname = structFieldnames{k};
writecell(myheaderstruct.(fieldname), excelFilename, 'Sheet', sprintf('%s_matlab', fieldname)); % add header
writematrix(myStruct.(fieldname), excelFilename, 'Sheet', sprintf('%s_matlab', fieldname),'WriteMode','append');
end
Error:
Invalid parameter name: WriteMode.
If 'WriteMode','append' isn't included, the header is overwritten.
Could someone suggest why `WriteMode` isn't working here?
This
writematrix(data.(fieldname), excelFilename,'-append', 'Sheet', sprintf('%s_simgraph', fieldname));
also doesn't work.
Wrong number of arguments. A filename must be provided when supplying additional parameters, and each parameter name must be followed by a value.
I'm using 2109b.
0 Kommentare
Akzeptierte Antwort
Walter Roberson
am 20 Mai 2020
Writemode is a new option as of R2020a.
3 Kommentare
Walter Roberson
am 20 Mai 2020
Read the existing sheet as cell. Pad it or the new data to have the same number of columns. Put the two parts together. Write out to the sheet.
Anthony Phipps
am 18 Okt. 2020
Bearbeitet: Anthony Phipps
am 18 Okt. 2020
This post is a life saver - thanks
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!