How to extract data from multiple excel files
显示 更早的评论
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 个）
Samatha Aleti
2019-8-19
0 个投票
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
2019-8-13
2019-8-19
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
