参考代码
Dim t As Table = Tables("教务处组织补考学生名单")
For Each n As String() In t.DataTable.GetValues("考场号|开课院系", "考场号 is not null" & iif(t.Filter>"", " and (" & t.filter & ")", ""))
Dim Book As New XLS.Book(ProjectPath & "Attachments\门贴.xls") '打开模板
Dim fl As String = ProjectPath & "教务处组织补考门贴\" & n(0) & "-" & n(1) & ".xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Sheet(1,3).Value = "<考场号='" & n(0) & "' and 开课院系='" & n(1) & "'>" '写入打印条件
Book.Build() '生成报表
Book.Save(fl)
Next