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?
Best Answer
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.
ZM - check to see if you have permission to read and write to that file. If you do, then consider using readtable instead of xlsread to see if that somehow (?) allows you to better read and write to the same file (as xlsread isn't recommended to be used).
Best Answer