Add new data into existing excel file

28 vues (au cours des 30 derniers jours)
Hazel Sialongo
Hazel Sialongo le 4 Oct 2016
Commenté : Cádmo Dias le 25 Mar 2019
I have an existing excel file and I want to add new data in a new column. How will I do that?

Connectez-vous pour répondre à cette question.

Réponse acceptée

Gareth Thomas
Gareth Thomas le 4 Oct 2016
If you use xlswrite with this code it should work:
filename = 'testdata.xlsx';
A = {'Time','Temperature'; 12,98; 13,99; 14,97};
sheet = 2;
xlRange = 'E1';
xlswrite(filename,A,sheet,xlRange)
Notice how the xlRange shows the columns.
  2 commentaires
Hazel Sialongo
Hazel Sialongo le 4 Oct 2016
I want to happen is every time I click the save button it will automatically save the data in another column.
Cádmo Dias
Cádmo Dias le 25 Mar 2019
First of all, thanks for your help,Gareth!
Hazel, I suggest to you increase the range, in "xlRange" variable, to change the column.

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Spreadsheets dans Help Center 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