Hide excel sheet form Excel file
조회 수: 10 (최근 30일)
이전 댓글 표시
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
댓글 수: 0
채택된 답변
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.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!