我在用Table 导出excel时,如何使excel页面为横向打印,打印比例为0.5等。
导出代码:
Response.Clear()
Response.ContentType = "application/ms-excel"
Response.AddHeader("Content-Disposition", "attachment;filename=MyExcel.xls")
Dim sw As StringWriter = New StringWriter
Dim htmlWriter As HtmlTextWriter = New HtmlTextWriter(sw) Me.tblMain.RenderControl(htmlWriter)
Response.Write(sw.ToString)
Response.End()
我该在何时加入什么代码才能实现此目的,我不想用excel对象哪样一个一个单元格填充,那实在太慢了。我想用这种控件的rendercontrol方法实现,恳求高手帮忙,不胜感激。
导出代码:
Response.Clear()
Response.ContentType = "application/ms-excel"
Response.AddHeader("Content-Disposition", "attachment;filename=MyExcel.xls")
Dim sw As StringWriter = New StringWriter
Dim htmlWriter As HtmlTextWriter = New HtmlTextWriter(sw) Me.tblMain.RenderControl(htmlWriter)
Response.Write(sw.ToString)
Response.End()
我该在何时加入什么代码才能实现此目的,我不想用excel对象哪样一个一个单元格填充,那实在太慢了。我想用这种控件的rendercontrol方法实现,恳求高手帮忙,不胜感激。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货