Extract data from multiple excel files
12 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Mariana
am 10 Jan. 2020
Kommentiert: Nusrat Chowhdury
am 30 Mär. 2022
I am trying to extract data from a specific column from multiple excel files and save this columns in one table
D = 'C:\Users\Desktop\Analyze\';
for k=1:250
file = sprintf('Data_%d.xlsx',k);
filename = strcat('C:\Users\TR8E1MQ\Desktop\Analyze\',file);
x = xlsread(filename);
T = x(:,7);
end
This how I am extracting one column. I want to keep those and keep adding more values from other excel files.
0 Kommentare
Akzeptierte Antwort
Guillaume
am 10 Jan. 2020
I would recommend you use fullfile instead of strcat to build paths. This way you don't have to worry about path separators.
Assuming that all files have the number of rows, this is how I'd do it:
source_folder = 'C:\Users\Desktop\Analyze'; %much more meaningful name than D
numfiles = 250;
data = []; %will be preallocated upon reading the first file, once we know the size of a column
for fileidx = 1:numfiles
filedata = readmatrix(fullfile(source_folder, sprintf('Data_%d.xlsx', fileidx)));
if fileidx == 1
data = zeros(size(filedata, 1), numfiles); %preallocate to the height of columns x num files
end
data(:, fileidx) = filedata(:, 7); %copy column 7 into output matrix
end
end
10 Kommentare
Nusrat Chowhdury
am 30 Mär. 2022
What is the code if I wanna take multiple columns of each excel file in the same way?
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!