Question

write a matlab code that can plot 3 excel files? this plot know can run one excel file of 20crackf1.

clc;
clear all;
close all;
data1=xlsread('20f1','spectrum - PXI1Slot4_ai0','A8:B10009');% Importing excel file
x=data1(:,1);
y=data1(:,2);
plot(x,y);
xlim([0 100]);
xlabel('Frequency in Hz');
ylabel('Amplitude in g');
title('FFT');
hold on;
data2=xlsread('20crackf1','a1','A1:B5000');
x1=data2(:,1);
y1=data2(:,2);
plot(x1,y1);
xlim([0 100]);

Answer 1

clc;
clear all;
close all;
%define the names of all the excel files,here first,second and third are the %name of the excel workbooks
excel_wb={'first.xlsx','second.xlsx','third.xlsx'}
%define the names of all the excel sheets,here one, two and threee are the %names of the excel worksheet
excel_sheet={'one','two','three'}
%define the range of all the excel sheets,below defines the range of the excel %workbook
excel_range={"A8:B10009","A1:B5000","A1:B5000"}
% loop runs thrice as the length of the excel_wb is 3
for i = 1:length(excel_wb)
data=xlsread(excel_wb(i,i),excel_sheet(i,i),excel_range(i,i))
x=data(:,1);
y=data(:,2);
plot(x,y);
xlim([0 100]);
xlabel('Frequency in Hz');
ylabel('Amplitude in g');
title('FFT');
end