老师,如图和如代码,我想点击打印的时候能自动根据内容新增,比如:我打印的内容有10行,那模版的地方就只有10行的内容,如是100行就100行的内容),因为目前设置的是10行,如果没有10行会有空白行,如果多于10行,就会出现多张,我想要
Dim Book As New XLS.Book(ProjectPath & "Attachments\采购订单合同.xlsx")
Dim fl As String = ProjectPath & "Reports\采购订单合同.xlsx"
Dim str As String = "-1,"
Dim t As Table = e.Form.controls("转合同").Table
For Each r As Row In t.GetCheckedRows
str &= r("_Identify") & ","
Next
Dim f As String = t.Filter
t.Filter = "[_Identify] in (" & str.trim(",") & ")"
book.sheets(0)(10,13).value = "<ALL>"
Book.Build() '生成细节区
Book.Save(fl) '保存工作簿
t.Filter = f
Dim Proc As New Process '打开工作簿
Proc.File = fl
'Proc.Verb = "Print" '指定动作
Proc.Start()
此主题相关图片如下:1.jpg