Error When Using Writetable

Question

0 个投票

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.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

Ive J 2021-1-16

0 个投票

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 = [];

NA 2021-1-16

Thank you so much.