Discover MakerZone

MATLAB and Simulink resources for Arduino, LEGO, and Raspberry Pi

Learn more

Discover what MATLAB® can do for your career.

Opportunities for recent engineering grads.

Apply Today

How to: For loops for Excel Tab

Asked by Hello kity on 24 Dec 2012

I need to read some data out of couple excel tabs (1 file). The only thing that changes is the tabname. The code works, but it becomes too long if you going to read 6 tabs, so i want it in a for loop then varie the tabname. What i want saved of each tab is: the num(2,13) (second line in code) and sum (last line). How can I do this easiest way?

[num, txt]=xlsread(filename,'*Tabname*');
*Tabname*=num(2,13);
long code
   *sumTabname*=sum(numeachcell);

0 Comments

Hello kity

Tags

Products

No products are associated with this question.

4 Answers

Answer by Laura Proctor on 24 Dec 2012
Accepted answer

If you know the names of your sheets, you can create a cell array containing those names. The output from the xlsread function will contain only the numeric data from the spreadsheet, and it is read into a cell in the variable data. I also created a variable named sums that contains the sum of all the data.

filename = 'Book1.xlsx';
sheetnames = { 'SheetA','SheetB','SheetC' };
n = length(sheetnames);
data = cell(n,1);
sums = zeros(n,1);
for idx = 1:n
    data{idx} = xlsread(filename,sheetnames{idx});   
    sums(idx) = sum(data{idx}(:));
end

0 Comments

Laura Proctor
Answer by Laura Proctor on 24 Dec 2012

I'm not sure exactly what you are asking with regard to num(2,13). But here is some code that will read in different tabs of an Excel file in a loop and can hopefully get you started.

filename = 'Book1.xlsx';
data = cell(3,1);
for idx = 1:3
    sheetname = ['Sheet',num2str(idx)];
    data{idx} = xlsread(filename,sheetname);    
end

0 Comments

Laura Proctor
Answer by Hello kity on 24 Dec 2012

I want 2 data as output from every sheet. the value in that num and the sum.

your code is for sheets1,2,3,4, my sheets are not numbered, just random names.

how can i define the sheetnames and let them use in the forloop?

0 Comments

Hello kity
Answer by Hello kity on 24 Dec 2012

This worked for me. Really useful information.

thank you

I have another question, see my profile,

it is about putting an enter in the x-axes (xtick), for example i have this below the first bar (in a bar graph)

Bar1 5/110 , but i want bar1 enter ('second line') 5/110

0 Comments

Hello kity

Contact us