How to use xlswrite to wirte excel sheet each time dynamically?

1 次查看（过去 30 天）
Rohit Bhoi
Rohit Bhoi 2016-2-20
回答： dpb 2016-2-20
I have a GUI in which there are 7 text boxes and 7 static boxes and one button. whenever I press button it perform some operation and gives result in 5,6,7 text box. now i have to write this data in excel sheet each time whenever user press button.How to do this?

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

回答（1 个）

dpb
dpb 2016-2-20
You have to decide where in the sheet you want the values written; xlswrite will not accept multiple ranges in a single call; you either have to write each cell with a separate call or define an array that covers the rectangular portion of the worksheet that is the target.
Or, use actxserver to create a COM automation server and manipulate Excel thru it.

类别

在 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