Why `WriteMode` isn't working while appending data to xlsx?

85 views (last 30 days)
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');
Invalid parameter name: WriteMode.
If 'WriteMode','append' isn't included, the header is overwritten.
Could someone suggest why `WriteMode` isn't working here?
This is a follow up to my previous post here.
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.

Accepted Answer

Walter Roberson
Walter Roberson on 20 May 2020

Sign in to comment.

More Answers (0)




Community Treasure Hunt

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

Start Hunting!

Translated by