Add new data into existing excel file

28 次查看（过去 30 天）
Hazel Sialongo
Hazel Sialongo 2016-10-4
评论： Cádmo Dias 2019-3-25
I have an existing excel file and I want to add new data in a new column. How will I do that?

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

采纳的回答

Gareth Thomas
Gareth Thomas 2016-10-4
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 个评论
Hazel Sialongo
Hazel Sialongo 2016-10-4
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 2019-3-25
First of all, thanks for your help,Gareth!
Hazel, I suggest to you increase the range, in "xlRange" variable, to change the column.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by