How can I read in rows from an Excel spreadsheet using iteration?

I am working with a spreadsheet Is there a way I can read in one row at a time in a for loop? this is the code which i have filename='ht2.xls'; xlRange = 'A(i):H(i)'; mat=xlsread(filename,xlRange);

ie i want to input data from i'th row column A to H

[Azzi Abdelmalek]

Why read one row each iteration?

[jojofernandis]

because i need data specifically of that row for my program

Answer 1

[Azzi Abdelmalek]

   filename='ht2.xls';
 mat=xlsread(filename);

Then use the row you want mat(k,:)

[jojofernandis]

The file is too big for that, it would take ages to read

[Azzi Abdelmalek]

Use

ii1=1;
ii2=10;
xlRange = sprintf('A%d:H%d',ii1,ii2)

[jojofernandis]

Yes it worked Thank you :)