Reading several Excel files

Hi,

I'm only the beginner in MATLAB and have a problem with reading of Excel files. There are 10 files that have only a little bit different names: '162rpm.xlsx', '324rpm.xlsx',...,'1620rpm.xlsx'. So I used this kind of code:

max_nummer=1620
k=1
for i=162:162:max_nummer
   A{k}=xlsread([num2str(i),'rpm_import.xlsx'])
k=k+1
end

Each Excel file has 2 first columns with about 1,000,000 rows and 10 columns with 100,000 rows. Each file has only one worksheet

So I need to read all data from files and there are 2 conditions:

1) it must be possible to read in the column not all, but each e.g. 100th row; 2)how can I choose the range e.g. 'A2:B100000' AND 'D1:E100000' at the same time with xlsread() ?

Thanks a lot in advance!

Answer 1

[David Sanchez]

1) It is not possible to read every 100 cells, but you can do:

r=1:100:1000;
f=xlsread('my_xls_file.xls');
f=f(r);

2) define your range as A2:E100000 and divide your array later

f = xlsread('my_xls_file.xls','A2:E100000');

Answer 2

[Artur]

Thanks a lot!