MATLAB Answers

0

MATLAB standalone application that includes Excel data template

Asked by ChiPhi85 on 26 Oct 2018
Latest activity Commented on by Image Analyst
on 15 Jan 2019
I would like to include an Excel spreadsheet within my standalone application that has a lot of formatting applied and will simply be filled with data and saved to a local drive. If I include it as a 'required file' during compilation, MATLAB opens it when I load the program. Obviously I can prompt the user to select the file or I can save the file in a specific directory, but is there any way to do it by storing the xlsx file as part of the program?

  3 Comments

Hi, let part by part break down what you are saying
Compile your application together with Excel spreadsheet
In this part, why don't you store your data in mat. file instead. Since user can't see the excel file as it is part of the your executable file.
Obviously I can prompt the user to select the file or I can save the file in a specific directory
If user want to select the file and write to a excel file saving in a sepcific directory, at this moment, you program read the mat.file and then write to excel by either readtable(), xlsread(), or ActiveX. It allows you to save the excel file in whatever directory you want.
but is there any way to do it by storing the xlsx file as part of the program?
Still same, I recommend to save your data in mat file and compile them in mat file.
Thanks for your response. I don't need the user to see the Excel file. The Excel file is just an empty template that I want to fill with data and then save to the users computer. It's just that it has nice formatting so they can just print it with all the data filled in.
For compilation, i'm still prefer save it as mat. file. if user want to print it, at that moment, in your program, you write your data to excel.

Sign in to comment.

1 Answer

Answer by Image Analyst
on 28 Oct 2018
 Accepted Answer

Use the -a option in mcc to include a file in your executable.

  7 Comments

Did this work for you? I want to do the same thing, however, can't get it to work.
Did you use the -a option, change MCR_CACHE_ROOT, or both?

Sign in to comment.