private void SaveToExcel(DataTable objTable)    {        int CountR = objTable.Rows.Count;//行数        int CountC = objTable.Columns.Count;//列数        Response.Clear();        Response.Buffer = true;         //设置Http的头信息,编码格式        Response.AppendHeader("Content-Disposition", "attachment;filename=result.xls");        Response.ContentType = "application/ms-excel";         //设置编码        Response.Charset = "GB2312";        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");        //写表头        for (int i = 0; i < CountC; i++)        {            Response.Write(objTable.Columns[i].ColumnName+"\t");        }        Response.Write("\n");        //写表内容        for (int RowNo = 0; RowNo <= CountR - 1; RowNo++)        {            string RowContent = "";            for (int CloumnNo = 0; CloumnNo <= CountC - 1; CloumnNo++)            {                RowContent += Convert.ToString(objTable.Rows[RowNo][CloumnNo]) + "\t";            }            RowContent += "\n";            Response.Write(RowContent);        }        Response.End();    }

评论