Can't read excel file using readtable and detectImportOptions after compiling the App. It works perfectly fine in the test environment
조회 수: 4 (최근 30일)
이전 댓글 표시
I have created an app using App Designer in 2021a. All the functionalities work well in the test environment. However, when I compile the app either as a standalone executable or a WebApp server, it fails to read the excel file that I'm uploading into the app. Below are the things that I've already tried:
- Using full filepath and file name in readtable
- Instead of uploading a an excel spreadsheet, I tried defining the path and filename as hard code in the app
Below is the screenshot from the WebApp log. It seems that the spreadsheet is not readable. I've also given link to access my entire application and the sample spreadsheets: Application and Files
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/625673/image.png)
댓글 수: 1
dpb
2021년 5월 21일
NB: the warning "Using Excel is not recommended for web apps"
I'd guess there's the root of the problem in that it doesn't have access to Excel runtime.
I've been building a coded app that also reads/writes Excel spreadsheets, but it's running on the local machine, not over the web, and it works just fine either as compiled or in test/development environment.
Also note it says it "Unable to open .... as a workbook" not that the file isn't found.
답변 (1개)
Marius Mueller
2021년 7월 21일
I have the exact same issue.
Everything was peachy in R2020b but once i switched to R2021a this error occurs.
I could not find any related information in the release notes.
Does anyone know of a workaround when the input format has to be excel?
댓글 수: 0
참고 항목
카테고리
Help Center 및 File Exchange에서 Use COM Objects in MATLAB에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!