How to hide sheet of excel file with matlab?
5 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hi,
I want to hide some sheets of my excel file through matlab. Kindly help me out.
Any suggestion is appreciated.
Thank you.
3 commentaires
Olaf Müller
le 5 Juin 2018
Hi Suraj,
hope my comment does not come too late ;-). Please try the approach as used for the example below:
Excel = actxserver('Excel.Application'); WB = invoke(Excel.Workbooks,'open', theFileName); WB.Worksheets.Item(1).Visible = 'xlSheetHidden'; WB.Worksheets.Item(1).Visible = 'xlSheetVisible';
Regards Olaf
Réponses (0)
Voir également
Catégories
En savoir plus sur Data Import from MATLAB 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!