Writetable logical table to excel as zeros and ones

Question

Erwin Werkhoven 2023-1-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1903285-writetable-logical-table-to-excel-as-zeros-and-ones

回答： Erwin Werkhoven 2023-2-6

Hi,

I have a large table containing only logicals. If I use writetable to write the table to a csv file, it writes ones and zeros. That's what I want.

% masks.accepted a table with only logicals

filterdump_file = fullfile(capmat_out_folder, "filterdump.csv");

writetable(masks.accepted, filterdump_file);

But if have write the exact same table to an excel file, it writes "true" and "false".

% masks.accepted a table with only logicals

capmat_out_file = fullfile(capmat_out_folder, strcat(capmat_file_basename, "_out.xlsx"));

writetable(masks.accepted, capmat_out_file, "Sheet", "Filter Dump", "AutoFitWidth",false);

Why does writetable write ones and zeros to a csv file, and "true" and "false" to an excel file? Besides that, writing to a csv file is done in a few seconds, but writing to an excel file takes like 10+ mins. How can I get matlab/writetable to write ones and zeros to an excel file?

Thanks in advance