http://topic.csdn.net/u/20081129/09/e5c69173-9037-4c7e-98f9-9349e1997698.html我现在需要做一个导出页面数据行到EXCEL并要求加入一段宏命令:
VB code
Sub Macro1()
'
' Macro1 Macro
' 宏由 user 录制,时间: 2008-11-28
''
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$5"
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.748031496062992)
.RightMargin = Application.InchesToPoints(0.94488188976378)
.TopMargin = Application.InchesToPoints(0.984251968503937)
.BottomMargin = Application.InchesToPoints(0.984251968503937)
.HeaderMargin = Application.InchesToPoints(0.511811023622047)
.FooterMargin = Application.InchesToPoints(0.511811023622047)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 300
.CenterHorizontally = True
.CenterVertically = False
.Orientation = xlPortrait
.Draft = False
.PaperSize = xlPaperA4
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
.Zoom = 80
.PrintErrors = xlPrintErrorsDisplayed
End With
End Sub 这段宏命令的目的是导出文件在打印的时候控制表头(也就是前五行)不动,让打印出来的每一页上面都有表头。 导出功能已实现了,现在的问题是如何在导出的这个EXCEL中加上上面那个宏命令,请大家指教!
VB code
Sub Macro1()
'
' Macro1 Macro
' 宏由 user 录制,时间: 2008-11-28
''
With ActiveSheet.PageSetup
.PrintTitleRows = "$1:$5"
.PrintTitleColumns = ""
End With
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.748031496062992)
.RightMargin = Application.InchesToPoints(0.94488188976378)
.TopMargin = Application.InchesToPoints(0.984251968503937)
.BottomMargin = Application.InchesToPoints(0.984251968503937)
.HeaderMargin = Application.InchesToPoints(0.511811023622047)
.FooterMargin = Application.InchesToPoints(0.511811023622047)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.PrintQuality = 300
.CenterHorizontally = True
.CenterVertically = False
.Orientation = xlPortrait
.Draft = False
.PaperSize = xlPaperA4
.FirstPageNumber = xlAutomatic
.Order = xlDownThenOver
.BlackAndWhite = False
.Zoom = 80
.PrintErrors = xlPrintErrorsDisplayed
End With
End Sub 这段宏命令的目的是导出文件在打印的时候控制表头(也就是前五行)不动,让打印出来的每一页上面都有表头。 导出功能已实现了,现在的问题是如何在导出的这个EXCEL中加上上面那个宏命令,请大家指教!
解决方案 »
- MVC 查询页面查询后无法显示查询结果
- 自动登录网站,急!
- 求一sql语句 (对不同分类的记录进行求和统计)
- 如何知道dataset当前记录号
- 如何在动态整数一维数组中添加记录 ?在线等,解决立马结帖
- 图片打印之后无法删除,是不是因为什么进程没有关呢?附上代码
- asp.net中如何实现让页面等待几秒,然后再跳转,郁闷了好几天
- 怎么在 web.config里面设置session超时时间
- 为什么我点下WEB控件(button)就会重新载入一次页面啊??
- 一个烦恼的问题,但请各位朋友帮我指点一下,谢谢!!!
- 验证码控件WebValidates如何实现点击后验证码变化?
- 在asp.net调用oracle的procedure 且procedure的out变量是record的
LeftMargin = Application.InchesToPoints(0.748031496062992)
.RightMargin = Application.InchesToPoints(0.94488188976378)
.TopMargin = Application.InchesToPoints(0.984251968503937)
.BottomMargin = Application.InchesToPoints(0.984251968503937)
.HeaderMargin = Application.InchesToPoints(0.511811023622047)
.FooterMargin = Application.InchesToPoints(0.511811023622047)
这段代码还没写出来。下面是宏的一部分,希望对你有用。
宏
ActiveSheet.PageSetup.PrintArea = ""
With ActiveSheet.PageSetup
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = "" c#
Microsoft.Office.Interop.Excel.Application vExcel =new Microsoft.Office.Interop.Excel.Application();
vExcel.Workbooks.Add(true);
vExcel.Visible = true;
Worksheet vWorksheet = (Worksheet)vExcel.Worksheets[2]; Range vRange = vWorksheet.PageSetup;
vWorksheet.PageSetup.PrintArea = "";
vWorksheet.PageSetup.LeftHeader = "";