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

3 views (last 30 days)
Aleksejs
Aleksejs on 12 Aug 2011
Answered: Scott on 26 Jun 2015
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

Answers (1)

Scott
Scott on 26 Jun 2015
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!