Hide excel sheet form Excel file
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Santosh Biradar
le 28 Juil 2022
Commenté : Santosh Biradar
le 28 Juil 2022
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 commentaires
Réponse acceptée
Jan
le 28 Juil 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.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!