CreatExcel()

public void CreatExcel(System.Data.DataTable dt, System.Web.UI.Page thisPage)
    {
        System.IO.StringWriter sw = new System.IO.StringWriter();
        string rowStr = "";
        //取所有列名
        for (int i = 0; i < dt.Columns.Count; i++)
        {
            rowStr = rowStr + dt.Columns[i] + "\t";
        }
        sw.WriteLine(rowStr);
        //取每行数据
        for (int j = 0; j < dt.Rows.Count; j++)
        {
            rowStr = "";
            for (int i = 0; i < dt.Columns.Count; i++)
            {
                rowStr = rowStr + dt.Rows[j][i].ToString() + "\t";
            }
            sw.WriteLine(rowStr);
        }
        sw.Close();
        string filename = DateTime.Now.ToString("yyyyMMddhhmmss");
        thisPage.Response.AddHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
        thisPage.Response.ContentType = "application/ms-excel";
        thisPage.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        thisPage.Response.Write(sw);
        thisPage.Response.End();
    }


 

keim,毕业于安徽科技学院理学院,2003年开始对Web开发有浓厚的兴趣,并专注于C#/java Web开发,软件架构设计、分布式相关、项目管理、前端设计等等,实战派...
posted @ 2009-05-21 13:37  夜色狼  阅读(140)  评论(0编辑  收藏  举报