Add worksheet with 'microsoft​.office.in​terop.exce​l'

2 次查看（过去 30 天）
Aleksejs
Aleksejs 2011-8-12
回答： Scott 2015-6-26
Guys,
saw some suggestions on how to add sheets when using actxserver('excel.application'). But am instead trying to cope with .Net ... Does anyone know how to add worksheets in my case?
NET.addAssembly('microsoft.office.interop.excel');
app = Microsoft.Office.Interop.Excel.ApplicationClass;
books = app.Workbooks;
newWB = books.Add;
app.Visible = true;
b = 4;
for i = 1:b
sheets = newWB.Worksheets;
if i > 3
% ??? Microsoft.Office.Interop.Excel.Worksheets.Add([],sheets.Item(3));
end
newSheet = sheets.Item(i);
newWS = Microsoft.Office.Interop.Excel.Worksheet(newSheet);
end
Thanks, Aleks

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

回答（1 个）

Scott
Scott 2015-6-26
This worked for me
self.hCurrentSheet = Microsoft.Office.Interop.Excel.Worksheet(self.hWorkbook.Worksheets.Add());

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by