Effacer les filtres
Effacer les filtres

Add new data into existing excel file

35 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?

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)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by