How to import column "x" from multiple excel workbooks and create a new excel file with imported columns?

3 次查看（过去 30 天）

Kundan 2013-7-18

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/82526-how-to-import-column-x-from-multiple-excel-workbooks-and-create-a-new-excel-file-with-imported-co

I am extremely new to MATLAB and with no prior programming experience. I have a fairly large dataset, stored in excel(*.xlsx) format(2 sheets in each workbook, each sheet size with approx 660000 x 30 cells).

I need to generate spreadsheet for individual variables which are stored in same column in multiple excel workbooks (e.g. variable lat would be in column2 in all workbooks. The script that I am using is working only for 10 spreadsheets and after 10 spreadsheet I am getting 0 values.

|%This script is used in extracting single excel column from multiple files 
%and writing them in another excel file
%%Load Data
dirs=dir('D:\NEE\*.xlsx');%read all the *.xlsx in the directory
%%Manipulate filenames
dircell=struct2cell(dirs); %Change the filename to strcture
filenames=dircell(1,:);
%%Read data up-to Row 17519 
num = (numel(filenames)); %
Newfile = zeros(17519,num); % Allocating memory 
%%Iteration
for i = 1:num
    Newfile(:,i) = xlsread(filenames{i}, 1, 'L2:L17520'); % create array
end
%%create a new excel file
xlswrite('LAT07.xls',Newfile); %|