Why does activate excel sheet 2 via ACTXSERVER return an error ?

3 visualizaciones (últimos 30 días)
Meng Li Gan
Meng Li Gan el 21 de En. de 2019
Comentada: Walter Roberson el 7 de Nov. de 2019
I am trying to activate sheet 2 of excel by using actserver, but it will return an error when I run my code. Can anyone explain what I had did wrong for my code?
your explaination will be greatly appreciated. My code is as below
e= actxserver('excel.application');
% Insert a new workbook.
eWorkbook = e.Workbooks.Add;
e.Visible = 1;
% Make the sheet active.
eSheets = e.ActiveWorkbook.Sheets;
eSheet1 = eSheets.get('Item', 2); % Want to edit 2nd sheet in workbook
eSheet1.Activate;
% Below is the error shown
% Error using Interface.Microsoft_Excel_16.0_Object_Library.Sheets/get
% Invoke Error, Dispatch Exception: Invalid index.
Besides, i am trying to write a set of data to excel with my own layout (merged cell, border line, colomn color), can I know where can I get the example or tutorial to use actxserver to write data to excel? Thanks in advance.
Regards, Lily
  2 comentarios
Henry Barth
Henry Barth el 7 de Nov. de 2019
This is an interesting question :-)
Walter Roberson
Walter Roberson el 7 de Nov. de 2019
At the moment as outside observers, we do not know that the workbook has more than 1 sheet after the Add is done.

Iniciar sesión para comentar.

Respuestas (0)

Categorías

Más información sobre Use COM Objects in MATLAB en Help Center y File Exchange.

Community Treasure Hunt

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

Start Hunting!

Translated by