Hide excel sheet form Excel file

4 views (last 30 days)
Hello
I have created 3 sheets in same excel. I want to Hide Sheet number 2.
excelFile3 = strcat('SummaryResult','.xlsx');
excelName3 = fullfile(selPath,excelFile3);
Excel = actxserver('Excel.Application');
Workbooks = Excel.Workbooks;
Workbook = Workbooks.Open(excelName3);
Sheets = Excel.ActiveWorkBook.Sheets;
Sheet = get(Sheets,'Item',1);
Sheet.Activate;
......
Script to modify
....
Sheet = get(Sheets,'Item',2);
Sheet.Activate;
......
Script to modify sheet formating
....
Sheet = get(Sheets,'Item',3);
Sheet.Activate;
......
Script to modify sheet formating
.
Workbook.Save;
Excel.Quit;
Excel.delete;
Thank You
I tried to use this link, but could not find the soltion

Accepted Answer

Jan
Jan on 28 Jul 2022
According to the links you have posted it should work like this:
Sheet = get(Sheets,'Item',2);
Sheet.Visible = 'xlSheetHidden';
You did not show, how you have tried it but only mentioned that you "could not find the solution". Therefore I cannot know, if you have tried the above code already.
  1 Comment
Santosh Biradar
Santosh Biradar on 28 Jul 2022
It worked!!!
Thank you so much @Jan.
Thankful for your answer and time.
I was using below script
%%
Sheet = get(Sheets,'Item',2);
Sheet.Activate;
invoke(Sheet,'Delete')
%%

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by