repeater 导出Excel
repeater 导出Excel ,导出的Excel文件没有边框线怎么办
[解决办法]
在repeater中显示时要能看到边框，比如用<table>,要加上border=“1”。要不就要在Excel中设置边框了
[解决办法]
protected void Excel_Click(object sender, EventArgs e)
{
Response.Clear();
//获取或设置一个值，该值指示是否缓冲输出，并在完成处理整个响应之后将其发送
Response.Buffer = true;
//获取或设置输出流的HTTP字符集
Response.Charset = "GB2312";
//将HTTP头添加到输出流
Response.AppendHeader("Content-Disposition", "attachment;filename=PriceManage" + DateTime.Now.Date.ToString("yyyyMMdd") + ".xls");
//获取或设置输出流的HTTP字符集
Response.ContentEncoding = System.Text.Encoding.UTF7;
//获取或设置输出流的HTTP MIME类型
Response.ContentType = "application/ms-excel";
System.IO.StringWriter onstringwriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter onhtmltextwriter = new System.Web.UI.HtmlTextWriter(onstringwriter);
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
this.Repeater1.RenderControl(htw);
string html = sw.ToString().Trim();
Response.Output.Write(html);
Response.Flush();
Response.End();
}
public override void VerifyRenderingInServerForm(Control control)
{
//base.VerifyRenderingInServerForm(control);
}
<script type="text/javascript">
//导出Excel
function AllAreaExcel(objtableid) {
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var sel = document.body.createTextRange();
sel.moveToElementText(document.getElementById(objtableid));
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
oXL.Visible = true;
}
</script>
<div>
<table id="table">
<tr>
<td>
<asp:Repeater ID="rpt" runat="server"></asp:Repeater>
</td>
</tr>
</table>
</div>
<div style="text-align: left">
<img src="images/dcexcel.gif" onclick='AllAreaExcel("table");' alt="repeater 导出Excel解决方法" style="cursor: hand;" />
</div>
