MATLAB Answers

Error When Using Writetable

31 views (last 30 days)
NA
NA on 16 Jan 2021
Commented: NA on 16 Jan 2021
I have this cell
Using the below code to make a table:
Table_1 = cell2table(g_final,'VariableNames',{'test1' 'test2' 'test3' ...
'test4' 'test5' 'test6'});
By using 'writetable'
filename = 'final_test.xlsx';
writetable(Table_WLS,filename,'Sheet',m,'Range','D1')
But I got this error:
Error using writetable
Dimensions of arrays being concatenated are not consistent.
I do not know, why I get this error and how to make it works.

Accepted Answer

Ive J
Ive J on 16 Jan 2021
test2 variable is the one causing this error. If you want that empty column in your output XLSX file:
Table_WLS.test2 = repmat({''}, size(Table_WLS, 1), 1); % or any alternatives converting 1X0 -> 0X0
But since it's empty, why not just remove it?
Table_WLS.test2 = [];
  1 Comment
NA
NA on 16 Jan 2021
Thank you so much.

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!