Importing Data from excel across multiple sheets and filenames.

358 views (last 30 days)
I am attempting to import multiple strings of data from excel spread sheets and was hoping that the same ranges across multiple sheets could be imported with the same command.
Was thinking it would be a for loop but was unsure how to set it up best.
A total of 8 data sets will be imported from 12 sheets. Any help is greatly appreciated or any questions. :)
  3 Comments
Guillaume
Guillaume on 25 Aug 2016
Yes, you can pass the same range to each call of xlsread, just as you can pass the same arguments to each call of a function.
It's very unclear what problem you are having.
Declan Simons
Declan Simons on 25 Aug 2016
Edited: Declan Simons on 25 Aug 2016
I have 12 columns of data that i want associate each with a unique variable. The same process would then need to happen to 12 sheets. So the total output would be 144 sets of data collected from the excel document. Hope that clears up what I'm trying to do.

Sign in to comment.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 25 Aug 2016
Edited: Azzi Abdelmalek on 25 Aug 2016
[~,sheet_name]=xlsfinfo('filename.xlsx')
for k=1:numel(shhet_name)
data{k}=xlsread('filename.xlsx',sheet_name{k})
end
Now all your data are in the variable data. You don't need to associate to each column a variable, because it's a very bad programming practice.
  3 Comments
GreenValleyB
GreenValleyB on 30 Jun 2022
is there a way to import data from different worksheets into one variable? Example: variableA contains data from column "B2:B100001" from worksheets X12, X13, X14, X15.
Walter Roberson
Walter Roberson on 9 Dec 2023
@Dyuman Joshi points out,
Answer needs to be updated to mention new robust functions such as writematrix(), writetable() and writecell(). And to notify that xlsread() is not recommended to use.

Sign in to comment.

More Answers (2)

Kristian Opsahl
Kristian Opsahl on 12 Sep 2018
Hi,
This code worked fine to import my data. However it does not import the dates that I have in column A on every sheet. Any workaround/solution to that?

Carlos Riascos
Carlos Riascos on 17 Feb 2023
I would recommend something like this:
[~,sheet_name]=xlsfinfo('filename.xlsx')
for k=sheet_name
[~,~,data.(k{1})]=xlsread('filename.xlsx',k{1});
end
Note: be careful with not having spaces or unallowed symbols in the sheet_name, otherwise use the command replace.

Community Treasure Hunt

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

Start Hunting!