# How can i use a loop for various sheet in excel?

2 views (last 30 days)
Ana Soph on 9 Jan 2020
Commented: Ana Soph on 9 Jan 2020
Hello everybody, i am new in matlab, and i have a very simple question...
i have eight sheets with datas and i wan to applied the mean and the sort for everyone in the column, and yes this programm do that, but i have to copy and paste for every document, for example this is for Temperature in eight years, but i want to continous with humidity, velocity of wind and other variables.
So if you can help me ,I would really appreciate it
this is my code:
k=1:8
for k=1:1
p=mean(HE1);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A1');
p=mean(HE2);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A2');
p=mean(HE3);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A3');
p=mean(HE4);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A4');
p=mean(HE5);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A5');
p=mean(HE6);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A6');
p=mean(HE7);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A7');
p=mean(HE8);
ps=sort(p);
xlswrite('datosexcel4.xlsx', ps, 'Hoja1', 'A8');
end

KALYAN ACHARJYA on 9 Jan 2020
Edited: KALYAN ACHARJYA on 9 Jan 2020
Excel_files=dir('C:\Work\steven_work\*.xlsx');
for i=1:length(Excel_files)
fName=strcat('C:\Work\steven_work\',Excel_files(i).name); % Excels Files Folder Path
[~,filename,~]=fileparts(fName);
xlswrite([filename,'.xlsx'],data1,'Sheet');
end
#Do minor mdification. as required. I hope you get the idea (Do Search other FAQ to call files, another option to use fullfile)
##### 2 CommentsShow 1 older commentHide 1 older comment
Ana Soph on 9 Jan 2020
i finally got it !
clear; clc
for i=1:8
p = mean(TE);
ps = sort(p);
A(i,:)= ps;
end
xlswrite('datosexcelprueba.xlsx', A, 'Hoja1','A1');

### Categories

Find more on Spreadsheets in Help Center and File Exchange

### Community Treasure Hunt

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

Start Hunting!

Translated by