Hide excel sheet form Excel file

2 次查看（过去 30 天）
Santosh Biradar
Santosh Biradar 2022-7-28
评论： Santosh Biradar 2022-7-28
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

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

采纳的回答

Jan
Jan 2022-7-28
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 个评论
Santosh Biradar
Santosh Biradar 2022-7-28
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')
%%

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by