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!