0 votes

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?

Connectez-vous pour répondre à cette question.

 Réponse acceptée

Ameer Hamza
Ameer Hamza le 16 Avr 2020

0 votes

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.

7 commentaires
Afficher 5 commentaires plus anciens Masquer 5 commentaires plus anciens

Ali K
Ali K le 16 Avr 2020
Perfect. It works.
Ameer Hamza
Ameer Hamza le 16 Avr 2020
Glad to be of help.
Ali K
Ali K le 16 Avr 2020
But It removes all other sheets. Why? I want to keep them.
Ameer Hamza
Ameer Hamza le 16 Avr 2020
The app use writetable function, which does not automatically delete all other sheets in R2020a. Which release are you using?
Ali K
Ali K le 16 Avr 2020
R2019b
Ali K
Ali K le 16 Avr 2020
It works, thank you.
Ameer Hamza
Ameer Hamza le 16 Avr 2020
Glad to be of help.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Spreadsheets dans Centre d'aide et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by