How to define range using a variable in xlsread?
23 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Rishabh Mittal
el 25 de Sept. de 2019
Comentada: Rishabh Mittal
el 27 de Sept. de 2019
I would like to read a row from excel file in Matlab. The row's staring and end columns are defined but I would like to use a variable to define the row number. I have tried the following:
row_no = 50;
x = xlsread('yourfile.xlsx', 'sheet', ['B50:EHI' num2str(row_no)]);
The above code allows the use of variable `row_no` to define the end cell `EHI50`. But can this also be done for referring to the starting cell `B50`?
0 comentarios
Respuesta aceptada
Adam
el 25 de Sept. de 2019
Editada: Adam
el 25 de Sept. de 2019
doc sprintf
can create a string out of variables, e.g.
columnStr = 'B';
startRow = 50;
endRow = 50;
sprintf( '%s%i:EHI%i', columnStr, startRow, endRow )
Or if you always want the same start and end row you can simplify it by using the same variable for both.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets 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!