Increment cell number in xlsread
7 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Bob Thompson
il 17 Ott 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.
Risposte (1)
Adam Danz
il 17 Ott 2019
Modificato: Adam Danz
il 21 Ott 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.
0 Commenti
Vedere anche
Categorie
Scopri di più su Data Import from MATLAB in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!