readcell does not import last columns when first columns are empty (2019a)
2 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Urmila Rajpurohith
2019-11-18
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 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Probability Distributions 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!