Filter löschen
Filter löschen

Add new data into existing excel file

35 Ansichten (letzte 30 Tage)
Hazel Sialongo
Hazel Sialongo am 4 Okt. 2016
Kommentiert: Cádmo Dias am 25 Mär. 2019
I have an existing excel file and I want to add new data in a new column. How will I do that?

Akzeptierte Antwort

Gareth Thomas
Gareth Thomas am 4 Okt. 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 Kommentare
Hazel Sialongo
Hazel Sialongo am 4 Okt. 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 am 25 Mär. 2019
First of all, thanks for your help,Gareth!
Hazel, I suggest to you increase the range, in "xlRange" variable, to change the column.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by