Increment cell number in xlsread

7 visualizaciones (últimos 30 días)
Christo van Rensburg
Christo van Rensburg el 17 de Oct. de 2019
Editada: Adam Danz el 21 de Oct. de 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 comentarios
Bob Thompson
Bob Thompson el 17 de Oct. de 2019
What do you mean by 'increment'? Are you looking to capture multiple cells at once over a range, something like every fifth cell in column E?
xlsread is a nice command, but every time you use it you have to open and close excel. If you are looking to read multiple values from the same excel sheet, I recommend reading the entire range you want first, and then indexing your way through the variable in matlab directly.
Christo van Rensburg
Christo van Rensburg el 17 de Oct. de 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.

Iniciar sesión para comentar.

Respuestas (1)

Adam Danz
Adam Danz el 17 de Oct. de 2019
Editada: Adam Danz el 21 de Oct. de 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.

Categorías

Más información sobre Data Import from MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by