read entire sheet in xlsread basic mode
조회 수: 6 (최근 30일)
이전 댓글 표시
I would like to read in the data on an entire excel sheet in linux. The size of the data is variable. From what i've read xlsread only works with the 'basic' option on linux. Is there any way to read the entire sheet?
When I try:
[num,txt,raw] = xlsread('myfile.xlsx','mySheetName','','basic')
all I get is the contents of the A1 cell.
Im using 2018b.
댓글 수: 0
답변 (1개)
Urmila Rajpurohith
2019년 11월 19일
“xlsread” is not recommended instead you can use “readtable” function to read entire excel sheet.
You can refer to the below documentation for more information on “readtable” function.
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!