Dim lst As new List(of String) For Each r As Row In Tables("员工").GetCheckedRows lst.Add(r("_Identify")) Next Dim filter = Tables("员工").Filter Tables("员工").Filter = "[_Identify] in (" & String.Join(",",lst.ToArray) & ")" Dim Book As New XLS.Book(ProjectPath & "Attachments\资产卡片.xls") Dim fl As String = ProjectPath & "Reports\资产卡片.xls" Book.Build() '生成细节区 Book.Save(fl) '保存工作簿 Dim Proc As New Process '打开工作簿 Proc.File = fl Proc.Verb = "Print" '指定动作 Proc.Start() Tables("员工").Filter = filter
|