Relations.Delete("asdf")
Dim dt3 As Table = Tables("订单主表")
Dim ids As String
If dt3.Current IsNot Nothing Then
With Tables("订单主表")
If .TopPosition > -1 Then '如果选定区域包括数据行
For i As Integer = .TopPosition To .BottomPosition
ids = ids & ",'" & dt3.Rows(i)("单号") & "'"
Next
End If
End With
ids= ids.Trim(",")
Relations.Add("asdf",DataTables("订单主表").DataCols("单号"),DataTables("订单明细表").DataCols("单号"))
Dim Book As New XLS.Book(ProjectPath & "Attachments\订单表.xls") '打开模板
Dim fl As String = ProjectPath & "Reports\订单表.xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
With Sheet.PrintSetting
.LandScape = False
.MarginLeft = 5 '左右边距设为20毫米
.MarginRight = 5
.MarginTop = 5 '上下边距设为15毫米
.MarginBottom = 5
End With
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)
Dim EndRow As Integer = Ws.Range("G65536").End(MSExcel.XlDirection.xlUp).Row '对A列从第1行开始向下查找,直到找到最后一个非空单元格为止,并得到其行号.也就是有内容的开始行
Dim FirstRow As Integer = Ws.Range("A1").End(MSExcel.XlDirection.xlDown).Row '对A列从第1行开始向下查找,直到找到最后一个非空单元格为止,并得到其行号.也就是有内容的开始行
Ws.Cells.PageBreak = MSExcel.XlPageBreak.xlPageBreakNone '清除所有分页符
For i As Integer = FirstRow To EndRow '
If ws.Rows(i).EntireRow.hidden = True Then
ws.Rows(i).EntireRow.delete
End If
Next i
Dim Endrow1 As Integer = ws.range("G65536").End(MSExcel.XlDirection.xlUp).Row
For t As Integer = Firstrow To Endrow1
If ws.cells(t-1,1).text Like "收货人*" Then
Ws.Rows(t).PageBreak = MSExcel.XlPageBreak.xlPageBreakManual
End If
Next t
With Ws.PageSetup
.PrintArea = "A" & FirstRow -3 & ":h" & Endrow1 '打印工作表的指定区域
'设置页面
.LeftMargin = 5 '页面左边距
.RightMargin = 5'页面右边距
.TopMargin = 5 '页面顶部边距
.BottomMargin = 5 '页面底部边距
.CenterHorizontally = True '页面水平居中
.CenterVertically = True '页面垂直居中
'设置页
.Orientation = MSExcel.xlPageOrientation.xlPortrait
'.Orientation = MSExcel.xlPageOrientation.xlLandscape
''缩放打印
'.Zoom = True '以下设置将缩印在一页内
'.FitToPagesWide = 1 '按照1页的宽度打印
'.FitToPagesTall = 1 '按照1页的高度打印
End With
App.Visible = True
Ws.PrintPreview
App.Quit
End If
加好友 
发短信
Post By：2018/4/8 10:36:00 [只看该作者]
此主题相关图片如下：qq图片20180408103627.png
