ActiveX VT_ERROR parameter when reading excel data from matlab. Workarounds?
조회 수: 3 (최근 30일)
이전 댓글 표시
When reading excel data from Matlab obtain the "ActiveX VT_ERROR" parameter. Is there an alternate method of reading the cell such that the cell's formula is evaluated and Matlab reads a number?
The cell's formula uses the "VLOOKUP" function which also uses the "INDIRECT" function to reference a second external worksheet. It is the "INDIRECT" reference to this external worksheet reference which prevents returning a number value via Matlab.
Issue occurs with xlsread and the ActiveX approach.
댓글 수: 0
답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 ActiveX에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!