MATLAB Answers

Naming output excel-file via edit field in Appdesigner

조회 수: 1(최근 30일)
Lennart Heid
Lennart Heid 2021년 6월 24일
편집: Adam Danz 2021년 6월 27일
Hello,
I am writing a code for a Matlab App for the data acquisition of several sensors. The data will be put into an array which will be saved as an excel-file when using a 'Stop'- pushbutton function. Currently, I am simply using the writetable function and change the name of the table within the code after every session:
writetable(app.T, 'filename.xlsx');
Since I have an interface, I would like to change the filename of the output excel table via a text edit field in the UI figure before starting a session. I know i can access the string of the edit field via the command 'app.DateinameEditField.Value', but how can I connect it to the writetable function?

채택된 답변

Adam Danz
Adam Danz 2021년 6월 24일
편집: Adam Danz 2021년 6월 24일
> I know i can access the string of the edit field via the command 'app.DateinameEditField.Value', but how can I connect it to the writetable function
filename = [app.DateinameEditField.Value, '.xlsx'];
writetable(app.T, filename)
You may want to include a section of code that validates the user's input to ensure it's a valid file name.
You may also want to include a section of code that checks whether the file exists or not because writetable will over-write files with the same file name and extension (or maybe you want to overwrite it). Another alternative is to append a string of random character like you often see in files within the temp directory.
  • If filename is the name of an existing text file, then the writing function overwrites the file.
  • If filename is the name of an existing spreadsheet file, then the writing function writes the data to the specified location, but does not overwrite any values outside the range of the input data.

추가 답변(0개)

제품


릴리스

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by