jsp 调用excel打印 如何用代码设置页面横打

zeroer

现在做一个工程，遇到打印问题，请高手赐教，急。
我用jsp点选“打印”连接后，连接到一个excel生成的jsp页。根据数据自动进行横打竖打设置。我不知道相关属性，请高手赐教。谢谢

jolin1981330

帮你顶

totlechao3

<%@ page contentType="application/vnd.ms-excel"%>

slt75kav

同问一下

sunman0918

帮顶，关注

悲雪狂沙

导出excel打印
private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
  {
   Response.Clear();
   Response.Buffer= true;
   
   Response.AppendHeader("Content-Disposition","attachment;filename=Borrow.xls");
   Response.ContentEncoding=System.Text.Encoding.GetEncoding("gb2312");

   Response.ContentType = "application/ms-excel";
   this.EnableViewState = false;
   
   System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true);
   System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad);
   System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
   
   Table3.RenderControl(oHtmlTextWriter);

   Response.Charset="gb2312";
   Response.Write(oStringWriter.ToString());
   Response.End();
  }

悲雪狂沙

控制"纵打"、 横打”和“页面的边距。
（1）<script defer>
function SetPrintSettings() {
　// -- advanced features
　factory.printing.SetMarginMeasure(2) // measure margins in inches
　factory.SetPageRange(false, 1, 3) // need pages from 1 to 3
　factory.printing.printer = "HP DeskJet 870C"
　factory.printing.copies = 2
　factory.printing.collate = true
　factory.printing.paperSize = "A4"
　factory.printing.paperSource = "Manual feed"  

　// -- basic features
　factory.printing.header = "This is MeadCo"
　factory.printing.footer = "Advanced Printing by scriptX"
　factory.printing.portrait = false
　factory.printing.leftMargin = 1.0
　factory.printing.topMargin = 1.0
　factory.printing.rightMargin = 1.0
　factory.printing.bottomMargin = 1.0
}
</script>

（2）
<script language="javascript">
　　function printsetup(){
　　// 打印页面设置
　　wb.execwb(8,1);
　　}
　　function printpreview(){
　　// 打印页面预览
　　　　
　　wb.execwb(7,1);
　　　　　
　　　　
　　}

　　function printit()
　　{
　　if (confirm(''确定打印吗？'')) {
　　wb.execwb(6,6)
　　}
　　}
　　</script>
</head>
<body>
<OBJECT classid="CLSID:8856F961-340A-11D0-A96B-00C04FD705A2"

height=0 id=wb name=wb width=0></OBJECT>
<input type=button name=button_print value="打印"

onclick="javascript:printit()">
<input type=button　name=button_setup value="打印页面设置"

onclick="javascript:printsetup();">
<input type=button　name=button_show value="打印预览"

onclick="javascript:printpreview();">
<input type=button name=button_fh value="关闭"

onclick="javascript:window.close();">

sss_zm

mark

weberzhu

嗯,js调用ie的打印控件

aizelasi

关注