1、读取excel变量名列
2、读取需要修改变量名与修改后变量名一一映射表
3、替换excel文件的变量名列
4、修改后的变量名列,写入excel文件
clear;
clc;
%读取需要修改的excel文件的变量名列
[num,data]=xlsread('P4MCU变量名映射表.xlsx','Sheet2');
Dataname=data(:,7);
length1=length(Dataname);
%读取修改变量名映射表格
[num1,data1] = xlsread('P4MCU变量名映射表.xlsx','Sheet3');
SearchData = data1(:,1);
ReplaceData = data1(:,2);
length = length(SearchData);
%替换excel文件的变量名列
for i=1:length1
for j=1:length
if strcmp(Dataname(i), SearchData(j))
Dataname(i) = ReplaceData(j);
end
end
end
%修改后的变量名列,写入excel文件
xlswrite('P4MCU变量名映射表.xlsx',Dataname,'Sheet2','G1');
clear;