Iteratively wants to change column while reading MS-Excel sheet

2 次查看（过去 30 天）
SYED AQEEL HAIDER
SYED AQEEL HAIDER 2018-9-11
编辑： Dennis 2018-9-11
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.

请先登录，再回答此问题。

采纳的回答

Dennis
Dennis 2018-9-11
编辑：Dennis 2018-9-11
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

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by