Increment cell number in xlsread

12 views (last 30 days)
Christo van Rensburg
Christo van Rensburg on 17 Oct 2019
Edited: Adam Danz on 21 Oct 2019
Hi
I'm reading values from a excel spreadsheet with xlsread as such:
exp.Vc = xlsread('BD.xlsx', 1, 'E9');
and was wondering if it is at all possible to increment the cell number I'm reading the data from?
Thanks in advance!
  2 Comments
Christo van Rensburg
Christo van Rensburg on 17 Oct 2019
So in my original question I read data from cell 'E5'. I want that to increase to cell 'E6' after I've run the program once and so on.

Sign in to comment.

Answers (1)

Adam Danz
Adam Danz on 17 Oct 2019
Edited: Adam Danz on 21 Oct 2019
Create the range value using sprintf() where you can specify both the column and row values. Then you can control the row number within a loop or just by providing a new row number.
col = 'E';
row = 7;
exp.Vc = xlsread('BD.xlsx', 1, sprintf('%s%d',col,row));
Alternatively, you can just read in all of the data at once and then using indexing to increment through those values.

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by