readcell does not import last columns when first columns are empty (2019a)
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Martin Jandacka
il 12 Nov 2019
Risposto: Urmila Rajpurohith
il 18 Nov 2019
readcell('test.xls') does not import last n columns, when first n columns are empty.
i.e. instead of
{missing} {missing} {a} {b} {c} {d}
I will get
{missing} {missing} {a} {b}
When I know the number of columns I have I can use i.e.:
readcell('test.xls', 'Range', 'A:F') - in this case I have the last columns, but the leading empty columns are removed:
{a} {b} {c} {d}
Is there a way to get all the columns (including empty one)?
Edit:
readcell('test.xls', 'Range', '') - helps when one do not know the number of columns, but do not include the missing leading rows.
0 Commenti
Risposta accettata
Urmila Rajpurohith
il 18 Nov 2019
If you know the number of columns, then you can use below commands to get all columns including the empty ones.
opts = spreadsheetImportOptions('NumVariables',6,'DataRange', 'A:F');
M = readcell('test.xlsx', opts);
0 Commenti
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Statistics and Machine Learning Toolbox 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!