Question

C#，如何把Listview中数据导成excel？

Answer 1

汗。楼上的两位答案一模一样。难道是一个人回答的? 呵呵开个玩笑。楼主你好： 很高兴为你解答有关C#方面的问题。对于该功能我有不相同的方法。因为前段时间。老师刚教过我们的，呵呵。首先要引入一个命名空间：Microsoft.Office.Interop.Excel;代码贴出。希望可以帮到楼主Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
excel.Visible = false;
excel.Application.Workbooks.Add(true);
for (int i = 0; i < this.listView1.Columns.Count; i++)//为excel添加标题
{
excel.Cells[1, i + 1] = listView1.Columns[i].Text;
}
for (int i = 0; i < listView1.Items.Count; i++)//添加每一项
{
for (int j = 0; j < listView1.Columns.Count; j++)
{
excel.Cells[i + 2, j + 1] = listView1.Items[i].SubItems[j].Text;
}
}
excel.DisplayAlerts = false;//和下面这个通常是一起用的
excel.AlertBeforeOverwriting = false;//设置禁止弹出保存和覆盖的询问提示框
excel.Application.Workbooks[1].Save();
excel.Application.Save("C:\\123.xsl");//保存路径。可以自定义，也可以通过savedialog对话框获取保存路劲

Answer 2

/// <summary>
/// 定义导出Excel的函数
/// </summary>
/// <param name="FileType">到处的类型</param>
/// <param name="FileName">路径名</param>
private void Export(string FileType, string FileName)
{
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = FileType;
this.EnableViewState = false;
StringWriter tw = new StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
datagridview1.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
/// <summary>
/// 此方法必重写，否则会出错
/// </summary>
/// <param name="control"></param>
public override void VerifyRenderingInServerForm(Control control)
{
}