Hide excel sheet form resulted Excel file

2022 7 28
1 个回答
更新时间：2022 7 28
42 次查看（30 天）

0 个投票

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

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

回答（1 个）

Ishan Gupta
Ishan Gupta 2022-7-28

0 个投票

1 个评论
显示 -1更早的评论 隐藏 -1更早的评论

Santosh Biradar
Santosh Biradar 2022-7-28
Hi I@Ishan Gupta
Thank you for your responce.
I checked it.
But unable to understand where and which lines to be added in the script.
Excel = actxserver('Excel.Application');
WB = invoke(Excel.Workbooks,'open', theFileName);
WB.Worksheets.Item(1).Visible = 'xlSheetHidden';
WB.Worksheets.Item(1).Visible = 'xlSheetVisible';
Could you please make it possible?
Your help would be very helpful.
Thanks again.

请先登录，再进行评论。

类别

在 帮助中心 和 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