Unable to write data into excel file in append mode

10 次查看（过去 30 天）
SILPA C S
SILPA C S 2021-9-29
编辑： Marcel 2022-11-30
filename = 'file.xlsx';
con = array2table(con);
T=array2table(M,'VariableNames',{'Accuracy','PPV','NPV','Sensitivity','Specificity','Mean Accuracy'});
writematrix('ConfusionMatrix',filename,'Sheet',1,'WriteMode','append')
writetable(con,filename,'Sheet',1,'WriteMode','append')
writecell({'Accuracy','PPV','NPV','Sensitivity_Recall_TPR','Specificity_Selectivity_TNR','Mean Accuracy'},filename,'Sheet',1,'WriteMode','append')
writetable(T,filename,'Sheet',1,'WriteMode','append') %'WriteVariableNames',false
Error:
Unable to determine range. Range must be of the form 'A1' (cell), 'A:B' (column-select), '1:5' (row-select), 'A1:B5'
(rectangle-select), or a valid named range in the sheet.
If we specify the range, it will show error range cannot be specified in append mode.
Kindly help to solve this issue
  1 个评论
Mathieu NOE
Mathieu NOE 2021-9-29
hi
seems a bit complicated , all these sucessive calls to writematrix / writetable / writecell
is there any chance to put together a single table and do only one call to writetable ?
also sharing the data (xls) files would help

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Marcel
Marcel 2022-11-30
编辑：Marcel 2022-11-30
Im using this code to append text to a excel file. You can also use the parameter "Range", "A1:G1" (untested), but you'd need to remove the "WriteMode" parameter, because you cant have both
writecell(cellstr("Test"), "file.xls", 'WriteMode','append');

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2021a

Community Treasure Hunt

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

Start Hunting!

Translated by