write Vietnamese words to a excel file

Question

Manh Nguyen 2017-1-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/320536-write-vietnamese-words-to-a-excel-file

回答： Walter Roberson 2017-1-16

Hi,

I want to write Vietnamese words from Matlab to a excel file. However, in the output is not as the same as input, error font. How can i solve it?

This is the code i use

filename = 'testdata.xlsx';
A = {'Vùng','Thủy triều: cao nhất 3,2 m, lúc 4h00, thấp nhất 0,7m, lúc 16h44'};
sheet = 1;
xlRange = 'A1';
xlswrite(filename,A,sheet,xlRange);

and the output is

Vung Th?y tri?u: cao nh?t 3,2 m, lúc 4h00, th?p nh?t 0,7m, lúc 16h44

Thanks,

Manh

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

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-1-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/320536-write-vietnamese-words-to-a-excel-file#answer_250710

在 MATLAB Online 中打开

I do not happen to have Excel for Windows available, so I could not test with xlswrite() directly. However, I found something that works, at least on new-ish versions of MATLAB:

writetable( cell2table(A), 'testdata.xlsx', 'WriteVariableNames', 0)