主题：Excel报表能批量生成

Excel报表能批量导出吗？请指教，谢谢

Dim Book As New XLS.Book(ProjectPath & "Attachments\学生资助申请表.xlsx")
Dim fl As String = ProjectPath & "Reports\学生资助_Table1.xlsx"
Book.Build()
Book.Save(fl)
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(fl)
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
App.Visible = True

 

此主题相关图片如下：qq截图20191204112724.png