Sometimes, Data was saved as Excel file format. And, it often contains strings and numerals in a column, we all know that Matlab reads the data as a m-by-n Cell Arrary. It is difficult to get and set all together, the following is an example to convert numerals to string in Cell Arrary.

Main Program:

clear;

clc;

% Read Two.xlsx For Values

% Num is an Arrary in Double, all numeralsare in it, and non-numerals all are filled in NaN.

[Num, ~, Values2]=xlsread('Two.xlsx','A1:BXQ1356');  

% Convert Values to CellStr Every Column

for ii=1:size(Num, 2)

  Values2(:, ii)=ReAssign(Num(:, ii), Values2(:, ii));

  fprintf('%d Col done!n', ii);

end

clear Num

Function ReAssign:

% Created by LI Xu

% 21 November, 2013

% Version 1.0

% Description

% Data from Excel Tables can be assigned toanother file

% in order.

function ColCells=ReAssign(ColNum, ColRaw)

num=ColNum;

raw=ColRaw;

% Index of Txt

Num=num2str(num);

Num=cellstr(Num);

Num=strfind(Num, 'NaN');

% Whether Empty Set

Index_Txt=logical(size(Num));

for ii=1:length(Num)

  Index_Txt(ii)=~isempty(Num{ii});

end

Index_Txt=Index_Txt';

% Index of Number

Index_Num=~Index_Txt;

raw(Index_Num)=cellstr(num2str(num(Index_Num)));

ColCells=raw;