导出

  目的：是为了统计数据，方便管理。了更为精确地确定某个体参照标准化样本的确切位置，我们需要把原始分数转换成某种相对测量。

 

代码如下：

using System; 
using System.Collections; 
using System.Configuration; 
using System.Data; 
using System.Web; 
using System.Web.Security; 
using System.Web.UI; 
using System.Web.UI.HtmlControls; 
using System.Web.UI.WebControls; 
using System.Web.UI.WebControls.WebParts; 
using System.Text; 

public partial class DataPage_NationDataShow : System.Web.UI.Page 
{ 
        private Data_Link link = new Data_Link(); 
        private string sql; 

protected void Page_Load(object sender, EventArgs e) 
{ 
    Ajax.Utility.RegisterTypeForAjax(typeof(DataPage_NationDataShow)); 
} 

protected void btnExcel_Click(object sender, EventArgs e) 
{ 
    string strExcelName = "MyExcel"; 
    strExcelName = strExcelName.Replace(@"/", ""); 

Data_Link link = new Data_Link(); 
string strSQL = this.hidParam.Value; 
DataSet ds = new DataSet(); 
ds = link.D_DataSet_Return(strSQL);//获得想要放入Excel的数据 

gvExcel.Visible = true; 
gvExcel.DataSource = null; 
gvExcel.DataMember = ds.Tables[0].TableName; 
gvExcel.DataSource = ds.Tables[0]; 
gvExcel.DataBind(); 

ExportToExcel(this.Page, gvExcel, strExcelName); 
} 

protected void gvExcel_RowDataBound(object sender, GridViewRowEventArgs e) 
{ } 
public override void VerifyRenderingInServerForm(Control control) 
{ } 

/// <summary> 
/// 工具方法，Excel出力(解决乱码问题) 
/// </summary> 
/// <param name="page">调用页面</param> 
/// <param name="excel">Excel数据</param> 
/// <param name="fileName">文件名</param> 
public void ExportToExcel(System.Web.UI.Page page, GridView excel, string fileName) 
{ 
try 
{ 
foreach (GridViewRow row in excel.Rows) 
{ 
for (int i = 0; i < row.Cells.Count; i++) 
{ 
excel.HeaderRow.Cells[i].BackColor = System.Drawing.Color.Yellow; 
} 
} 
excel.Font.Size = 10; 
excel.AlternatingRowStyle.BackColor = System.Drawing.Color.LightCyan;
excel.RowStyle.Height = 25; 

page.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName); 
page.Response.Charset = "utf-8"; 
page.Response.ContentType = "application/vnd.ms-excel"; 
page.Response.Write("<meta http-equiv=Content-Type content=text/html;charset=utf-8>"); 
excel.Page.EnableViewState = false; 
excel.Visible = true; 
excel.HeaderStyle.Reset(); 
excel.AlternatingRowStyle.Reset(); 

System.IO.StringWriter oStringWriter = new System.IO.StringWriter(); 
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); 
excel.RenderControl(oHtmlTextWriter); 
page.Response.Write(oStringWriter.ToString()); 
page.Response.End(); 

excel.DataSource = null; 
excel.Visible = false; 
} 
catch (Exception e) 
{ 

} 
} 
}