read and search an excel file with Arabic or Persian column

2 次查看（过去 30 天）
Nooshin Mahmoodi
Nooshin Mahmoodi 2018-10-19
评论： Nooshin Mahmoodi 2018-10-19
I have an excel file with Arabic or Persian column, I want to search in this Persian column and find the repeated word in this column. But because it is Persian word, the Matlab read them as "NAN". is there anyone that know, how could I solve this problem? thanks in advance
  3 个评论
显示 1更早的评论
Nooshin Mahmoodi
Nooshin Mahmoodi 2018-10-19
this file has three sheets with the Persian column and the first row is the name of variables in each sheet, for example, I need to search in the 4th column, that in the first sheet, just have seven different values, then I want to get average for the similar one.

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2018-10-19
With R2018b, It looks like your spreadsheet can be read correctly using either xlsread or readtable.
[~, ~, raw] = xlsread('test.xls')
or
t = readtable('test.xls')
Some rows of the table don't display properly in the command window but are displayed properly in the variable browser. In addition, since matlab does not accept arabic characters for variable names, all the column names are mangled. But otherwise, everything appears to work properly
>> find(strcmp(t.(15), 'بتونی و فلزی')) %find 'بتونی و فلزی' in column 15
ans =
15
18
>> mean(t.(14)) %mean of column 14
ans =
5.375

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by