Effacer les filtres
Effacer les filtres

Problem on acessing excel by activeX command in Matlab

2 vues (au cours des 30 derniers jours)
Bibi
Bibi le 24 Juin 2014
Commenté : Bibi le 8 Juil 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"
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.

Réponse acceptée

Tejas M U
Tejas M U le 30 Juin 2014

Plus de réponses (0)

Produits

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by