Write table to excel

2020 4 16
1 个回答
回答已采纳
更新时间：2020 4 16
7 次查看（30 天）

0 个投票

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?

请先登录，再回答此问题。

 采纳的回答

Ameer Hamza
Ameer Hamza 2020-4-16

0 个投票

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 个评论
显示 5更早的评论 隐藏 5更早的评论

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

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by