- Reads XLS, XLSX, XLSM, XLTX, and XLTM files only.
- Does not support an 'xlRange' input when reading XLS files. In this case, use '' in place of 'xlRange'.
- Does not support function handle inputs.
- Imports all dates as Excel serial date numbers. Excel serial date numbers use a different reference date than MATLAB date numbers
What are the limitations of XLSREAD when run in 'basic' mode?
조회 수: 8 (최근 30일)
이전 댓글 표시
MathWorks Support Team
2010년 5월 6일
편집: MathWorks Support Team
2022년 10월 14일
I am unable to invoke Microsoft Excel as an automation server. As a result, I must use XLSREAD in 'basic' mode. I would like to know the limitations of XLSREAD when running in 'basic' mode.
채택된 답변
MathWorks Support Team
2022년 10월 14일
편집: MathWorks Support Team
2022년 10월 14일
On Windows systems with Microsoft Excel software, "xlsread" reads any file format recognized by your version of Excel.
If your system does not have Excel for Windows, "xlsread" operates in "basic" import mode.
Flag to request reading in 'basic' mode, specified as the literal string, 'basic'
'basic' mode is the default for systems without Excel for Windows. In 'basic' mode, "xlsread"
The appropriate syntax for using "xlsread" in 'basic' mode may be found in the following documentation page:
You may access the same page locally by typing the following at the MATLAB prompt:
web(fullfile(docroot, 'matlab/ref/xlsread.html'))
댓글 수: 0
추가 답변 (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!