DataTables("课程表").Save()
DataTables("学习记录").Save()
DataTables("课程记录").Load
Dim xh1 As String
Dim xz As Boolean
xh1=Tables("课程表").Current("序号")
xz=Tables("课程表").Current("选择")
Dim Book As New XLS.Book(ProjectPath & "Attachments\升班通知1.xls") '打开模板
Dim fl As String = ProjectPath & "Reports\升班通知1.xls"
Dim Sheet As XLS.Sheet = Book.Sheets(0)
Sheet(1,7).Value = "<序号 = '" & xh1 & "' and 选择 = false>"
Book.Build() '生成报表
Book.Save(fl)
Dim Proc As New Process
Proc.File = fl
Proc.Start()
Dim App As New MSExcel.Application
Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(ProjectPath & "\Attachments\升班通知1.xls")
Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(1)
With Ws.PageSetup
'设置页眉
.LeftHeader = "打印日期: &D" '左页眉,&D表示日期
.CenterHeader = "&""隶书,常规""&20 数据分析表" '中页眉,并将字体设置为隶书和20号字大小
.RightHeader = "打印者: " & App.UserName '右页眉
'设置页脚
.LeftFooter = "文件: &F &A" '左页脚,&F表示文件名,&A表示工作表名
.CenterFooter = "" '中页脚为空
.RightFooter = "第 &P 页 共 &N 页" '右页脚
'打印模式
.Orientation = MSExcel.xlPageOrientation.xlPortrait '纵向打印
.Orientation = MSExcel.xlPageOrientation.xlLandscape '横向打印
.PrintHeadings = True'打印行号和列标
.PrintGridlines = True '打印网格线
'缩放打印
.Zoom = False'以下设置将缩印在一页内
.FitToPagesWide = 1 '按照1页的宽度打印
.FitToPagesTall = 1 '按照1页的高度打印
End With
App.Visible = True
Ws.PrintPreview
App.Quit
加好友 
发短信
Post By：2017/12/6 12:10:00 [显示全部帖子]
此主题相关图片如下：360截图20171206172430890.jpg
