How to hide sheet of excel file with matlab?

15 views (last 30 days)
I want to hide some sheets of my excel file through matlab. Kindly help me out.
Any suggestion is appreciated.
Thank you.
Olaf Müller
Olaf Müller on 5 Jun 2018
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

Sign in to comment.

Answers (0)


Community Treasure Hunt

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

Start Hunting!