根据选中项,如何批量生成报表并且按编号命名文件?已编代码如下,该如何改进?
Dim s As String = Tables("附属物情况").rows(0)("编号") & Tables("附属物情况").rows(0)("权利人姓名")
Dim Book As New XLS.Book(ProjectPath & "Attachments\附属物.xls") '打开模板
Dim fl As String = ProjectPath & "Reports\" & s & "附属物" & ".xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Sheet(5, 10).Value = "<日期 = # " & Date.Today & "#>" '写入打印条件
Book.Build() '生成报表
Book.Save(fl)
Dim Proc As New Process
Proc.File = fl
Proc.Start()