110,539
社区成员
发帖
与我相关
我的任务
分享
private void Button4_Click(object sender, System.EventArgs e)
{ string searchcon=SearchStr_Excel();
SqlConnection con = new SqlConnection(ConnectionString);
SqlDataAdapter adapter=new SqlDataAdapter(searchcon ,ConnectionString+ ";Connect Timeout=3000");
DataTable pDataTable=new DataTable();
adapter.Fill(pDataTable);
int tRowCount = pDataTable.Rows.Count;
int tColumnCount = pDataTable.Columns.Count;
Response.Expires = 0;
Response.Clear();
Response.Buffer = true;
Response.Charset = "utf-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "attachment; filename=Excel.xls");
Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>");
// Response.Write("<style type=\"text/css\">.format{mso-number-format:\'\@\';}<\style>");
Response.Write("<Table borderColor=black border=1>");
Response.Write("\n <TR>");
for (int i = 0; i < tColumnCount; i++)
{
Response.Write("\n <TD bgcolor = #fff8dc>");
Response.Write(pDataTable.Columns[i].ColumnName);
Response.Write("\n </TD>");
}
Response.Write("\n </TR>");
for (int j = 0; j < tRowCount; j++)
{
Response.Write("\n <TR>");
for (int k = 0; k < tColumnCount; k++)
{
// if (k==0)
// {
// Response.Write("\n<TD style='mso-number-format:\"@\">");
// }
// else
Response.Write("\n <TD align=\"right\" style='vnd.ms-excel.numberformat:@'>");
Response.Write(pDataTable.Rows[j][k].ToString());
Response.Write("\n </TD>");
}
Response.Write("\n </TR>");
}
Response.Write("</Table>");
Response.End();
}
<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>
<table width="1700" id="table" border="0" cellspacing="0" cellpadding="0" style="text-align: center;table-layout: fixed;">
<asp:Repeater ...>
//你报表的主体部分在这里写
</asp:Repeater>
</table>
<div style="text-align: left">
<img src="images/dcexcel.gif" onclick='AllAreaExcel("table");' alt="导出到Execl" style="cursor: hand;" />
</div>