[求助]EXCEL报表页面设置代码放在哪里? Post By:2008/9/29 13:26:00 [显示全部帖子]
EXCEL报表页面设置代码放在哪里?要指定是哪一张报表吗?岂不是每张报表都横向输出?
Dim
Book As New XLS.Book Dim Sheet As XLS.Sheet = Book.Sheets(0) With Sheet.PrintSetting .PaperKind = 9 '设为A4纸 .LandScape = True '横向打印 .MarginLeft = 10'左右边距设为20毫米 .MarginRight = 10 .MarginTop = 15 '上下边距设为15毫米 .MarginBottom = 15 End With