txt2xlsx.m
close all
clc
clear
disp('txt 2 excel');
set_file = 'txt2xlsx_set.xlsx';
[~,~,c] = xlsread(set_file,'info');
N = c{1,1};
for k = 1:N
in = c{k+1,2};
out = c{k+1,3};
txt = c{k+1,4};
xlsx = c{k+1,5};
d = importdata([in,txt]);
xlswrite([out,xlsx],d.data);
end
txt2xlsx_set.xlsx
info sheet
3 | in folder | out folder | txt | excel | |
---|---|---|---|---|---|