I have 4 spreadsheets with about 20 rows. I'm trying to take the data from the same row in each spreadsheet and process it like so: A1 = xlsread(filename,'cluster','A1:AD1'); A2 = xlsread(filename,'Variance','A1:AD1'); ……. How can I make a loop that increases the row number each time it runs? I tried this code but it gives an error
for i=1:20xlRange = 'A',i,':AD',iA1 = xlsread(filename,'cluster', xlRange);A2 = xlsread(filename,'Variance', xlRange);end
Best Answer