Hide excel sheet form Excel file

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

https://in.mathworks.com/matlabcentral/answers/179238-how-to-hide-sheet-of-excel-file-with-matlab

...https://in.mathworks.com/matlabcentral/answers/179238-how-to-hide-sheet-of-excel-file-with-matlab

Answer 1

[Jan]

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.

[Santosh Biradar]

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')

%%