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=1620k=1for i=162:162:max_nummer A{k}=xlsread([num2str(i),'rpm_import.xlsx'])k=k+1end
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!
Best Answer