MATLAB Answers

Trouble reading 6 excel files (with multiple sheets) and storing each excel as a its own matrix with my loop.

1 view (last 30 days)
JM
JM on 29 Mar 2018
Commented: JM on 29 Mar 2018
Here is my current code
%My Code
foldername = 'My Folder Path';
files = dir(fullfile(foldername, '*.xlsx'))
for i = 1:length(files)
data = xlsread(fullfile(foldername,files(i).name));
end
This code works in some respect, however data only seems to hold 1 sheet from 1 excel file, despite the files variable having all 6 files in a 6x1 struct.
Ideally what I would like is 6 separate variables (or one that stores all six files, where I can reference specific files) in my workspace.
Then, I want to be able to reference data{sheets{columns/rows across every sheet}}. I believe I can do this part, its more so getting past the hurdle of importing each excel file.
Hope that makes sense and someone can offer some advice. Thank you.
  1 Comment
Elias Gule
Elias Gule on 29 Mar 2018
you are overwriting the values stored in the variable "data" in that for loop. So the data stored in the variable will be from the last file that was processed.

Sign in to comment.

Answers (2)

Elias Gule
Elias Gule on 29 Mar 2018
Doing this might help: Replacing
data = xlsread(fullfile(foldername,files(i).name));
with
data{i} = xlsread(fullfile(foldername,files(i).name));
where data{i} contains data from the ith file.
  1 Comment
JM
JM on 29 Mar 2018
Hi Elias, Thank you for the quick response.
I made the change you suggested and it seems to be taking the code in the right direction, however now I am getting 1x6 cell in data that contains the first sheet of each of the 6 excel files instead of containing all 30 sheets for each excel. Any idea why this might be?
Thank you.

Sign in to comment.


Elias Gule
Elias Gule on 29 Mar 2018
ok, lets do this then:
foldername = 'My Folder Path';
files = dir(fullfile(foldername, '*.xlsx'))
for i = 1:length(files)
xldata = xlsread(fullfile(foldername,files(i).name));
data{i} = xldata;
end
  1 Comment
JM
JM on 29 Mar 2018
Hey Elias,
With this code I am getting a 1x6 cell that has 6 sheets again and xldata has a 3006x20 double which is the contents of 1 sheet.
For some reason it still wants to only take the first sheet of each file in the data variable.

Sign in to comment.

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!