Clear Filters
Clear Filters

write Vietnamese words to a excel file

2 views (last 30 days)
Manh Nguyen
Manh Nguyen on 16 Jan 2017
Answered: Walter Roberson on 16 Jan 2017
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

Answers (1)

Walter Roberson
Walter Roberson on 16 Jan 2017
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)

Categories

Find more on Introduction to Installation and Licensing in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!