Add worksheet with 'microsoft.office.interop.excel'
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
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
0 Kommentare
Antworten (1)
Scott
am 26 Jun. 2015
This worked for me
self.hCurrentSheet = Microsoft.Office.Interop.Excel.Worksheet(self.hWorkbook.Worksheets.Add());
0 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!