Write table to excel

I want to read data from excel in a table (in appdesigner) and edit some of them and then update them (writting the modified data) again in excel file. How can I do that?

Answer 1

[Ameer Hamza]

See the attached file for an example. A sample excel file is also attached. Clicking the load button will open a dialog box. Select the excel file, and the app will load its content in a table. Now change the content and press the save button. The content of the original file will be changed.

[Ali K]

Perfect. It works.

[Ameer Hamza]

Glad to be of help.

[Ali K]

But It removes all other sheets. Why? I want to keep them.

[Ameer Hamza]

The app use writetable function, which does not automatically delete all other sheets in R2020a. Which release are you using?

[Ali K]

R2019b

[Ali K]

It works, thank you.

[Ameer Hamza]

Glad to be of help.