Problem on acessing excel by activeX command in Matlab
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
I tested code below
Excel = actxserver('Excel.Application');
set(Excel,'Visible',1);
Workbooks = Excel.Workbooks.Open('C:\Users\Bibi\Documents\MATLAB\New Microsoft Excel Worksheet.xlsx');
Excel.Worksheets.Add
Then I found I successfully added a new sheet "sheet2" before "sheet1"
But I searched for excel objects in http://msdn.microsoft.com/en-us/library/office/ff821537(v=office.15).aspx
Actually, one can arrange the order of the sheet by adding count and before just as below,
Worksheets.Add *Count:=2, Before:=Sheets(1)
But how to add "Count" and "Before" in matlab language, I tried many times but all failed.
0 Kommentare
Akzeptierte Antwort
Tejas M U
am 30 Jun. 2014
Have you tried the below link: http://www.mathworks.com/matlabcentral/answers/2603-add-a-new-excel-sheet-from-matlab
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!