Exporting data to excel every time a program is run

1 次查看（过去 30 天）
Con
Con 2013-2-11
I want to be able to write data to an excel spreadsheet after running a program. I know how to do this once, but I want to be able to run the program many times and add the data to excel each time, without overwriting the previous data in the spread sheet. For example:
a = x^2;
If I run this for x=1, I can get my answer and export it to excel ok. But if I run the exact same program again for x=2, I want it to write the answer to the same spreadsheet as the first one without overwriting the original data. My program is much more complex than this obviously but I want to get a general sense of how it's done.
I would prefer methods that don't involve any loops.

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

采纳的回答

ChristianW
ChristianW 2013-2-11
x = 1:100;
a = x.^2;
xlswrite('xls_test',a)

更多回答（1 个）

Srinivas
Srinivas 2013-2-11
编辑：Srinivas 2013-2-11
look for the sheet and range options in xlswrite
'I want it to write the answer to the same spreadsheet as the first one without overwriting the original data' what does this mean, you want to shift the previous output downwards.

类别

在 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