解决导出电子表格 当数字过多

导出按钮：

protected void ImageButton2_Click(object sender, ImageClickEventArgs e) { if (sgv1.Rows.Count == 0) { Response.Write("<mce:script type="text/javascript"><!--alert('数据库为空！')// --></mce:script>"); } else { ObjectDataSource1.SelectParameters.Clear(); ObjectDataSource1.SelectMethod = "get1"; ObjectDataSource1.TypeName = "excel"; ObjectDataSource1.DataBind(); sgv1.Columns.Clear(); sgv1.AutoGenerateColumns = true; sgv1.AllowPaging = false; sgv1.RowDataBound += new GridViewRowEventHandler(sgv1_RowDataBound); sgv1.DataBind(); daochu(); } }

 

sgv1_RowDataBound：

protected void sgv1_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { e.Row.Cells[15].Attributes.Add("class", "text"); e.Row.Cells[1].Attributes.Add("class", "text"); } }

daochu（）：

public void daochu() { string style = @"<style> .text { mso-number-format:/@; } </script> "; Response.ClearContent(); HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default; Response.AddHeader("content-disposition", "attachment;filename=hyjjb.xls"); Response.ContentType = "application/vnd.xls"; System.IO.StringWriter stringWrite = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite); sgv1.RenderControl(htmlWrite); Response.Write(style); Response.Write(stringWrite.ToString()); Response.End(); }