Read and process multiple sheets from Excel to Matlab
조회 수: 1 (최근 30일)
이전 댓글 표시
Hi!
I have an Excel file with N sheets.
Each sheet contains two coloumns (x and y coordinates of a curve).
I want to read them in Matlab at once, save data and plot them.
Any suggestion?
Thank you
댓글 수: 2
Mitchell Thurston
2021년 12월 21일
the second argument in xlsread is the sheet number, https://www.mathworks.com/help/matlab/ref/xlsread.html#bthgbma
you can either iterate through the sheet numbers in a loop, or just define the sheets you want to read. As far as I know, there isn't an automatically "read all of the sheets". hope this helps
채택된 답변
Stephen23
2021년 12월 21일
편집: Stephen23
2021년 12월 21일
Untested, but this should get you started:
P = 'absolute or relative path to where the files are saved';
F = 'filename.xlsx';
S = sheetnames(fullfile(P,F));
N = numel(S);
C = cell(1,N);
for k = 1:N
C{k} = readtable(fullfile(P,F), 'Sheet',S(k));
end
댓글 수: 0
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Data Import from MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!