Ext.Net 1.x_Ext.Net.GridPanel - Excel导出方法实现

public void ToExcel(GridPanel gp, string fileName, DataTable dt, HttpResponse resp)
        {
            resp.Clear();
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls");
            resp.ContentType = "application nd.ms-excel"; string colHeaders = "", ls_item = ""; int i = 0; int cl = gp.ColumnModel.Columns.Count; string columns = ""; //输出表头  取得数据表各列标题，各标题之间以t分割，最后一个列标题后加回车符  for (i = 0; i < cl; i++)
            { if (i == (cl - 1))//最后一列，加n  { if (!gp.ColumnModel.Columns[i].Hidden)
                    {
                        colHeaders += gp.ColumnModel.Columns[i].Header;
                        columns += gp.ColumnModel.Columns[i].DataIndex + ",";
                    }
                    colHeaders += "\n";
                } else { if (!gp.ColumnModel.Columns[i].Hidden && gp.ColumnModel.Columns[i].ColumnID != "update")
                    {
                        colHeaders += gp.ColumnModel.Columns[i].Header + "\t";
                        columns += gp.ColumnModel.Columns[i].DataIndex + ",";
                    }
                }
            }
            resp.Write(colHeaders); if (columns != "") columns = columns.Substring(0, columns.LastIndexOf(",")); string[] columnall = columns.Split(',');
            cl = columnall.Length; //逐行处理数据  for (int j = 0; j < dt.Rows.Count; j++)
            { //当前行数据写入HTTP输出流，并且置空ls_item以便下行数据  for (i = 0; i < cl; i++)
                { if (i == (cl - 1))
                    {
                        ls_item += EditString(dt.Rows[j][columnall[i].ToString()].ToString()) + "\n";
                    } else {
                        ls_item += EditString(dt.Rows[j][columnall[i].ToString()].ToString()) + "\t";
                    }
                }
                resp.Write(ls_item);
                ls_item = "";
            }
            Response.Flush();
            resp.End();
        } ///  /// 处理字符问题 ///  ///  ///  private static string EditString(string text1)
        { if (text1.IndexOf('\r') != -1)
            {
                text1 = text1.Replace('\r', ' ');
            } if (text1.IndexOf('\n') != -1)
            {
                text1 = text1.Replace('\n', ' ');
            } if (text1.IndexOf('\t') != -1)
            {
                text1 = text1.Replace('\t', ' ');
            } if (text1.IndexOf("'") != -1)
            {
                text1 = text1.Replace("'", "");
            } if (text1.IndexOf(@"""") != -1)
            {
                text1 = text1.Replace(@"""", "");
            } return text1;
        }

 ///  /// 导出Excel ///  protected void ToExcel(object sender, EventArgs e) 
        { 
            DataTable dtSource = _createPageManager.GetTrackBillData(mouldId, 2, "", 1, Cache); 
            ToExcel(gpExec, "test", dtSource, Response);  
        }

 <ext:Button ID="btnExportExcel" AutoPostBack="true" OnClick="ToExcel" runat="server" Text="导出Excel"> <Listeners> <Click Fn="saveData" />