导出为excel时 怎么把按钮也输入excel表了
代码: string ss = "";
HttpResponse res = Page.Response;
res.Clear();
res.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString() + ".xls");
res.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); //不转换编码就导出后可能会出现乱码
res.ContentType = "application/ms-excel"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); for (int i = 0; i < DataGrid1.Items.Count; i++)
{
ss = "";
for (int j = 0; j < DataGrid1.Columns.Count; j++)
{
if (j > 0)
{
ss += "\t";
}
ss += DataGrid1.Items[i].Cells[j].Text;
}
stringWrite.WriteLine(ss);
}
res.Write(stringWrite);
//res.Output.Write(stringWrite.ToString());
代码: string ss = "";
HttpResponse res = Page.Response;
res.Clear();
res.AddHeader("content-disposition", "attachment; filename=" + DateTime.Now.ToString() + ".xls");
res.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); //不转换编码就导出后可能会出现乱码
res.ContentType = "application/ms-excel"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); for (int i = 0; i < DataGrid1.Items.Count; i++)
{
ss = "";
for (int j = 0; j < DataGrid1.Columns.Count; j++)
{
if (j > 0)
{
ss += "\t";
}
ss += DataGrid1.Items[i].Cells[j].Text;
}
stringWrite.WriteLine(ss);
}
res.Write(stringWrite);
//res.Output.Write(stringWrite.ToString());
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货