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

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

Answer 1

[Scott]

This worked for me

self.hCurrentSheet = Microsoft.Office.Interop.Excel.Worksheet(self.hWorkbook.Worksheets.Add());