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

조회 수: 19(최근 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());

Community Treasure Hunt

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

Start Hunting!

Translated by