what should I include in the code that read the data from specific sheet of excel file
조회 수: 2 (최근 30일)
이전 댓글 표시
Hi,
I have excel file with around 12 sheet basically 12 experimental data and I would like to make my life easier by putting the line of code into the existing code that it will read the sheet name and plot the data from that sheet, with code below it is only reading the data from the first sheet..... I am googling from last hour but I couldnt't find something relevant coming. It be a great time saving help if you guys can help.
Current code:
a=readmatrix('Head_Pressure_all.ods');
% I want to add a sort of code line here where the code can into file 'Head_Pressure_all.ods' and read the data from that sheet
x=a(:,4);
y=a(:,8);
figure(1)
plot(x,y,'x','LineWidth',0.5);
hold on
댓글 수: 0
채택된 답변
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!