Problem on acessing excel by activeX command in Matlab
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Bibi
el 24 de Jun. de 2014
Comentada: Bibi
el 8 de Jul. de 2014
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 comentarios
Respuesta aceptada
Tejas M U
el 30 de Jun. de 2014
Have you tried the below link: http://www.mathworks.com/matlabcentral/answers/2603-add-a-new-excel-sheet-from-matlab
Más respuestas (0)
Ver también
Categorías
Más información sobre ActiveX en Help Center y File Exchange.
Productos
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!