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.
