Matlab executable does not open excel file

5 次查看(过去 30 天)
Hi All,
I created a matlab executable that should open an excel file with couple of sheets, read info from there and use the info in the code in order to elaborate the final information that I need.
When I run the code in Matlab it works totally fine - it opens the excel file, reads and keep working.
When I run the executable created with ApplicationCompiler in the "for_testing" folder that is generated, when I select the .xlsx file that the code needs to read it pops up an error message saying:
"Unable to open file 'vehicle.xlsx' as workbook. Check that the file exists, read access is available, and the file is a valid spreadsheet file."
Code-wise speaking, I am creating a GUI:
1- in the main code, below the GUI function "OpeningFcn", I am recalling a .m file (included in the application compiler list).
2- this .m file contains the following code:
[filename1,pathname1] = uigetfile('*.xlsx','Select VEHICLE PARAMETERS file');
table = readtable(filename1,'Sheet','names');
Since I am coding on R2019a, I am not using xlsread since on the guide is not reccomended.
Thanks in advance

采纳的回答

Vinai Datta Thatiparthi
Hello Antonio,
While compiling the executable application, include the Excel file along too. Use the '-a' flag for this. Make sure that the Excel exists and has the correct path available to the compiled program.
These discussions on the MATLAB Answers forum might provide you better context:
  • Including data file with standalone executable: LINK
  • Using Excel data with standalone executable: LINK
  • Read & Write data to Excel sheet with a standalone executable: LINK
Hope this helps!
  3 个评论
Vinai Datta Thatiparthi
Glad to know that you made it work, Antonio!
Stay safe!

请先登录,再进行评论。

更多回答(0 个)

产品


版本

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by