MATLAB Answers

Rana
1

Read Arabic Text from Excel and print it

Asked by Rana
on 17 Dec 2011
Latest activity Edited by Walter Roberson
on 20 Sep 2016
I read Arabic Text from Excel, I need to print it in text file I can see the value in debugging in variable editor but when I print it in file it printed as symbols
here is the code
[num,txt,raw] = xlsread(file_name,'All','B1:B10');
filO = fopen(fname, 'w');
for im=1:(size(txt,1))
x=cell2mat(txt(im));
fwrite(filO,x)
end
the output file contains the following
ےےے ےےےے ےےےےے ےےے ےےےےے ےےےےےےے ےےے ےےے ےےےےے ےےےےے ےےےےے ےےےےےے
where is the problem please?

  0 Comments

Sign in to comment.

2 Answers

Answer by Walter Roberson
on 17 Dec 2011
 Accepted Answer

  2 Comments

Rana
on 17 Dec 2011
thank you very much for your response
I tried all solutions it didn't give correct value
the problem that the value stores in variable is Arabic as I viewed it by variable editor among debugging , but it not printed correctly in text file
You probably need to open the text file with 'wt' and UTF-8 attributes, and probably need to fprintf() the characters rather than fwrite() them, so that they will be translated to UTF-8.

Sign in to comment.


Answer by Michael Katz on 17 Dec 2011

It might be matter of encoding, that is fwrite might be using ASCII or windows-1252. Try making the file UTF-8
fid = fopen(fname,'w','n','UTF-8')

  1 Comment

Rana
on 17 Dec 2011
thank you very much for your response
I tried the solution it didn't give correct value
the problem that the value stores in variable is Arabic as I viewed it by variable editor among debugging , but it not printed correctly in text file

Sign in to comment.