Importing Data from excel across multiple sheets and filenames.

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. :)

[Azzi Abdelmalek]

8 data sets will be imported from 12 sheets. What does that mean?

[Guillaume]

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]

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.

Answer 1

[Azzi Abdelmalek]

[~,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.

[Rohan Maharjajn]

@Azzi Abdelmalek now how to access the individual data from different sheets for further calculations

[vlernest]

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]

@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.

Answer 2

[Kristian Opsahl]

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?

[NAGENDRA ACHANTA]

Use [~,~,data{k}] instead of data{k}

Answer 3

[Carlos Riascos]

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.