用vba打开,然后,处理。或者清除密码。
Dim App As New MSExcel.ApplicationDim Wb As MSExcel.WorkBook = App.WorkBooks.Open("D:\test.xls",password:="123")Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)app.Visible = True
http://www.foxtable.com/help/topics/2121.htm