Additionally, the 10000 files have a common extension .xls and different names. However, the names are numerical and increase sequentially by a factor of 1 e.g 001.xls, 002.xls etc.
Indexing several Data files to extract a column from each file
1 view (last 30 days)
Show older comments
Hello,
I have 10000 different *.xls files. I have imported them to my workspace and would like to extract only column 3 from each of the 10000 files. Each file has 10 columns.
Having extracted the 3rd column from each file, I would like to preallocate a matrix where the 10000 columns would be stored as my output file.
Assume that my file has length(15000) as it contains daily precipitation timeseries for a long period.
I appreciate your response.
Zilefac.
3 Comments
Matt J
on 18 Oct 2012
Clarify what "length(15000)" means. Is it the number of rows in the desired output?
Accepted Answer
Azzi Abdelmalek
on 18 Oct 2012
Edited: Azzi Abdelmalek
on 18 Oct 2012
A=zeros(15000,1000);
for k=1:1000
filename=sprintf('file%d.xls',k)
num=xlsread(filename)
A(:,k)=num(:,2)
end
0 Comments
More Answers (1)
Sachin Ganjare
on 18 Oct 2012
With xlsread command you can read partcular column in xls file.
Below link will be useful in this regard:
Hope it helps!!!
0 Comments
See Also
Categories
Find more on Standard File Formats in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!