How do i plot the x-y coordinates on the same graph for all the 500 sheets of excel file?

Hello, i am quite new to matlab. I have an excel file which contains 500 sheets, with each of then containing coordinates (column a represent x-axis and b represents y-axis). I wanted to plot a x-y coordinate graph containing the coordinates from each sheet (all plotted on the same graph). How do i do this?

Answer 1

[Jan]

Create an axes and enable that existing objects are not overwritten. Then import the data in a loop and draw them:

ax = axes('NextPlot', 'add');  % Same as: "hold all"
for iSheet = 1:500
  Data = xlsread(FileName, iSheet, 'A:B');
  plot(Data(:, 1), Data(:, 2));
end