public partial class DataToExcel : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
DataAccess.DataClassesDataContext db = new DataClassesDataContext();
var qu = from t in db.TXLInfos
select t;
Response.AppendHeader("Content-Disposition", "attachment;filename=result.xls");
Response.ContentType = "application/ms-excel";
Response.Charset = "gb2312";
Response.ContentEncoding = Encoding.GetEncoding("gb2312");
System.IO.StringWriter writer = new System.IO.StringWriter();
foreach(TXLInfo item in qu)
{
writer.Write(item.GQName);
writer.Write("t");
writer.Write(item.GQID);
writer.WriteLine();
}
Response.Write(writer.ToString());
Response.End();
}
} 这是网上找的方法,现在只能导出每列的数据,我想要在每列数据加上标题该如何实现呢?现有数据导出的结果是:
张三 1
李四 2
王五 3我想要的是:
姓名 id
张三 1
李四 2
王五 3
excelc#.net
解决方案 »
- AjaxPro与ASP.NET AJAX1.0冲突的问题 急~~ 在线等
- SELECT问题
- 获取下拉菜单位值时
- 求援：请教正则式高手!!!
- DropDownList数据选择的问题？
- TEXTBOX:怎么调用它的值当文本类型是password
- asp.net 分层的标志是什么?
- 关于存储过程的问题
- 在VS.net 2003中，无法建立新的web应用项目，错误: http/1.1 500 internal server error
- 在datalist中有(string)dlist.DataKeys[e.Item.ItemIndex]，但是在repeater中却不支持，怎么办？
- asp.net mvc 搜索的SEO匹配问题
- 关于Ajax 的， ，报错 啦，
writer.Write(item.GQName);
writer.Write("t");
writer.Write(item.GQID);
writer.WriteLine(); 上面这段代码就是只能导出姓名和id的数据
/// <summary>
/// 的形式生成导出
/// </summary>
/// <param name="table">要导出的表</param>
/// <param name="fieldsDescr"><ColumnName,Descipt[,#String|#Datetime]> 以此格式的字段说明</param>
/// <param name="IsOutNoFields">是不输出filedsDescr不包含的列</param>
/// <returns>生成的HTML</returns>
public static String ExportCSV(DataTable table, List<String> fieldsDescr, Boolean IsOutNoFields)
{
StringBuilder strCSV = new StringBuilder(); //先导标题行
for (int i = 0; i < table.Columns.Count; i++)
{
DataColumn cl = table.Columns[i]; var query = from c in fieldsDescr
where c.IndexOf(cl.ColumnName + ",") != -1
select c;
//有说明否
if (query.Count() < 1 && !IsOutNoFields)
continue; if (query.Count() < 1)
strCSV.Append(cl.ColumnName);
else
{
String c = query.First();
Regex reg = new Regex(@",\w*,?");
Match m = reg.Match(c); if (m.Success)
strCSV.Append(m.Value.Replace(",", ""));
else
strCSV.Append(cl.ColumnName);
} if (i + 1 < table.Columns.Count)
strCSV.Append(",");
} strCSV.Append("\r\n"); //生成数据
foreach (DataRow r in table.Rows)
{
for (int i = 0; i < table.Columns.Count; i++)
{
var query = from c in fieldsDescr
where c.IndexOf(table.Columns[i].ColumnName + ",") != -1
select c; //有说明否
if (query.Count() < 1 && !IsOutNoFields)
continue;
if (query.Count() < 1)
strCSV.Append(r[i].ToString());
else
{
String cl = query.First();
if (cl.IndexOf(",#String") != -1 || cl.IndexOf(",#Datetime") != -1)
strCSV.Append("#" + r[i].ToString());
else
strCSV.Append(r[i].ToString());
} if (i + 1 < table.Columns.Count)
strCSV.Append(",");
}
strCSV.Append("\r\n");
} return strCSV.ToString();
}
#endregion
String strCSV = ExportCSV(tab, new List<String>() {
"Id,标识",
"Name,姓名"
}, false); String strFile = HttpUtility.HtmlEncode("Employee.csv");
return File(Encoding.GetEncoding("GB2312").GetBytes(strCSV), "application/octet-stream", strFile);
{
Response.Clear();
Response.Buffer = true;
Response.Charset = "UTF-8";
string filename = this.Title + System.DateTime.Now.Year.ToString() + System.DateTime.Now.Month.ToString() + System.DateTime.Now.Day.ToString() + System.DateTime.Now.Hour.ToString() + System.DateTime.Now.Minute.ToString() + ".xls";
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(filename));
Response.ContentEncoding = System.Text.Encoding.UTF8;
// Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8");
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 dto_Complaint_Info.Sign = 0;
dto_Complaint_Info.StartDate = txtCreateDateBegin.Value;
dto_Complaint_Info.ResetUser = txtCreateDateEnd.Value == "" ? "" : Convert.ToDateTime(txtCreateDateEnd.Value).AddDays(1).ToString("yyyy-MM-dd");
if (txtCreateDateBegin.Value == "" && txtCreateDateEnd.Value != "")
{
dto_Complaint_Info.ResetUser = txtCreateDateEnd.Value;
} dto_Complaint_Info.ShenPiDate = txtShenPiDateBegin.Value;
dto_Complaint_Info.ShenPiUser = txtShenPiDateEnd.Value == "" ? "" : Convert.ToDateTime(txtShenPiDateEnd.Value).AddDays(1).ToString("yyyy-MM-dd");
if (txtShenPiDateBegin.Value == "" && txtShenPiDateEnd.Value != "")
{
dto_Complaint_Info.ShenPiUser = txtShenPiDateEnd.Value;
} dto_Complaint_Info.EndDate = txtEndDateBegin.Value;
dto_Complaint_Info.BoHuiUser = txtEndDateEnd.Value == "" ? "" : Convert.ToDateTime(txtEndDateEnd.Value).AddDays(1).ToString("yyyy-MM-dd");
if (txtEndDateBegin.Value == "" && txtEndDateEnd.Value != "")
{
dto_Complaint_Info.BoHuiUser = txtEndDateEnd.Value;
} DataTable dt = dao_Complaint_Info.Complaint_Agent_Percent(dto_Complaint_Info).Tables[0]; StringBuilder sbTable = new StringBuilder(); sbTable.Append("<table style=\"border:1px; border-color:Red;\"><tr>"); for (int i = 1; i < dt.Columns.Count; i++)
{
switch (dt.Columns[i].ColumnName)
{
case "AgentName":
sbTable.Append("<td>" + "经销商" + "</td>");
break;
case "Percent48":
sbTable.Append("<td>" + "48小时解决率" + "</td>");
break;
case "Percent72":
sbTable.Append("<td>" + "72小时解决率" + "</td>");
break;
case "Percent240":
sbTable.Append("<td>" + "10天解决率" + "</td>");
break;
}
}
sbTable.Append("</tr>"); if (dt.Rows.Count > 0)
{
for (int h = 0; h < dt.Rows.Count; h++)
{
sbTable.Append("<tr>");
for (int j = 1; j < dt.Columns.Count; j++)
{
sbTable.Append("<td>" + dt.Rows[h][j].ToString() + "</td>");
}
sbTable.Append("</tr>");
}
}
sbTable.Append("</table>");
Response.Output.Write(sbTable);
Response.Flush();
Response.End();
}
catch (Exception ex)
{
Response.Write("<script language='javascript'>alert('" + ex.Message + "');</script>");
}