Clear Filters
Clear Filters

Error When Using Writetable

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

More Answers (0)

Categories

Find more on Structures in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!