How to hide sheet of excel file with matlab?

5 次查看（过去 30 天）
Suraj Srivastava
Suraj Srivastava 2015-2-19
评论： Olaf Müller 2018-6-5
Hi,
I want to hide some sheets of my excel file through matlab. Kindly help me out.
Any suggestion is appreciated.
Thank you.
  3 个评论
显示 1更早的评论
Suraj Srivastava
Suraj Srivastava 2015-2-19
Hi Ganesh,
I have multiple sheet in my excel file. I want to hide one or more sheets.
Hope now I am clear to you. Thank you.
Olaf Müller
Olaf Müller 2018-6-5
Hi Suraj,
hope my comment does not come too late ;-). Please try the approach as used for the example below:
Excel = actxserver('Excel.Application'); WB = invoke(Excel.Workbooks,'open', theFileName); WB.Worksheets.Item(1).Visible = 'xlSheetHidden'; WB.Worksheets.Item(1).Visible = 'xlSheetVisible';
Regards Olaf

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by