试用软件

how to clear content of a sheet in excel

5 次查看（过去 30 天）

显示更早的评论

Nan Shen 2012-3-6

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31389-how-to-clear-content-of-a-sheet-in-excel

回答： Jash Kadu 2022-7-14

Code is here:

Excel = actxserver('Excel.Application');

set(Excel, 'Visible', 1);

book = invoke(Excel.Workbooks,'Open',fileName);

curSheet = Excel.ActiveWorkbook.Sheets;

Sheets = Excel.Worksheets;

Rsheet = get(Sheets, 'Item', 'Result');

invoke(Rsheet, 'Activate');

Rsheet.Cells.Clear

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Jash Kadu 2022-7-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/31389-how-to-clear-content-of-a-sheet-in-excel#answer_1007105

Hi!

Please find the attached documentation :

https://www.mathworks.com/discovery/matlab-excel.html

https://www.mathworks.com/help/simbio/ref/content.html?s_tid=answers_rc2-2_p5_MLT

You can also go through examples in them.

You can also go through the MATLAB answer : https://www.mathworks.com/matlabcentral/answers/42312-excel-clearing-sheet-content?s_tid=answers_rc1-2_p2_MLT

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

类别

Computational Finance Spreadsheet Link Data Import from MATLAB

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Translated by

试用软件