MSEXCEL如何判断隐藏的sheet Post By:2020/9/14 17:21:00 [显示全部帖子]
如何循环判断某一个EXCEL的所有SHEET是否被隐藏?
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook =
App.WorkBooks.Open("D:\Report.xls") For Each Ws As MSExcel.WorkSheet In
Wb.WorkSheets MessageBox.Show(Ws.Name) Next App.Quit