Iteratively wants to change column while reading MS-Excel sheet

I am writing a code to read data from an excel sheet column-wise. The excel sheet is having 50 data columns. Each column has 50 data entries/rows. I want to read all 50 columns one by one using some loop. I know that 'xlsread' is to used but how to change the range of cells i.e 'A1:A50', 'B1:B50', ... so on for every new iteration of loop.

Answer 1

[Dennis]

I recommend to use xlsread just once to retrieve all your data. They will already be stored in a neat cell structure ready to be processed. You can loop over the cell instead.

xlswrite('test.xls',randi(10,10,50)); %some random data
[~,~,raw]=xlsread('test.xls');
raw{:,5} %column 5 values