清空筛选条件
清空筛选条件

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

3 次查看（过去 30 天）
Meng Li Gan
Meng Li Gan 2019-1-21
评论： Walter Roberson 2019-11-7
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

请先登录，再回答此问题。

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by