How to extract data from multiple excel files
조회 수: 2 (최근 30일)
이전 댓글 표시
I am attempting to create a 3D map of 101 sets of data, each set is in a seperate excel spreadsheet, all sets are within 1 folder.
My MatLAB knowledge is minimal, but this is my attempt at the code:
nFiles=101
filenamePrefix='F1--Trace-no loop-0000--0000';
filenameExtension='.csv';
for i = 1:nFiles
filename = [filenamePrefix, int2str(i), filenameExtension];
tmpData = readmatrix(filename, 'NumHeaderLines',1)
x{i}=tmpData(:,1);
y{i}=tmpData(:,2);
end
mesh(x{i},y{i},i}
Please give any advice or alternative codes that could work
댓글 수: 1
dpb
2019년 8월 13일
"create a 3D map of 101 sets of data, "
Can you explain precisely what the end result wanted is and what the data are/how they relate to the desired result?
As to alternatives, I'd probably start with something like--
d=dir('F1--Trace-no loop-0000--0000*.csv'); % return all files
for i=numel(d)
tmpData = readmatrix(d(i).name, 'NumHeaderLines',1);
...
It's what's next that depends on what it is wanting to do with the data and what it is that the data are.
답변 (1개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!