Matalab 中如何用一个cell存储多个字符串并将其一次性写入EXcel中

来源：互联网发布：软件ui设计编辑：程序博客网时间：2024/04/20 08:15

%%读入数据[schoolID,schoolName] = xlsread('Problem C - IPEDS UID for Potential Candidate Schools.xls','A2:B2978');lengthOfOrigin = length(schoolID);%%匹配ID%              A~Efor alphabet = 0:4        selectedSchoolID = xlsread('ID.xls',[char('A' + alphabet) '1:' char('A' + alphabet) '2389' ]);%    lengthOfselected = length(selectedSchoolID);    index_SelectedSchoolName = 1;for index_SelectedID = 1 : lengthOfselected    index_Origin = find(schoolID == selectedSchoolID(index_SelectedID));    selectedSchoolName{index_SelectedSchoolName} = char(schoolName(index_Origin));    %xlswrite('schoolName',selectedSchoolName(index_SelectedSchoolName),'sheet1',[char('A' + alphabet)  num2str(index_SelectedSchoolName)]);    index_SelectedSchoolName  = index_SelectedSchoolName + 1;end    xlswrite('selectedSchoolIDAndName',selectedSchoolID,['sheet' num2str(alphabet+1)],[char('A')  num2str(1) ':' char('A') num2str(2389)]);    xlswrite('selectedSchoolIDAndName',selectedSchoolName',['sheet' num2str(alphabet+1)],[char('B')  num2str(1) ':' char('B') num2str(2389)]);end

其中selectedSchoolName即一个cell数组。

注意：

1.向cell赋值的方式

selectedSchoolName{1} = 'xxx';

<pre name="code" class="plain">selectedSchoolName{2} = 'yyy';

2.将一个cell转换为字符串的方式：

char(schoolName(index_Origin));

3.将一个cell中的字符串一次性写入Excel中方式

<pre name="code" class="plain">xlswrite('selectedSchoolIDAndName',selectedSchoolName',['sheet' num2str(alphabet+1)],[char('B')  num2str(1) ':' char('B') num2str(2389)]);

0 0