sharepoint将gridview导出到excel

最新推荐文章于 2024-10-11 17:50:32 发布

Bradwarden

最新推荐文章于 2024-10-11 17:50:32 发布

阅读量1.3k

点赞数

分类专栏： sharepoint 文章标签： sharepoint excel exception string .net object

本文链接：https://blog.csdn.net/Bradwarden/article/details/7644035

版权

sharepoint 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

虽然sharepoint基于.net技术，但是对于一些.net基本实现方法在sharepoint仍然是有区别的，sharepoint 中将gridview导出到excel，就与.net有所区别。具体见讲解

方法一：使用GridViewExportUtil 辅助类

protected void lkbtnExport_Click(object sender, EventArgs e)
        {
            try
            {
                GridViewExportUtil.Export("PlannedTools.xls", gvPlanedTools, null);
            }
            catch(Exception ex) {
                panError.Visible = true;
                lbError.Text = ex.Message;
            }
        }

方法二：用另一种方法将gridview导出到excel，但是当gridveiw中有一些特殊列，如：身份证，这是导出的excel用此种方法会出现科学计数，而并非真实的身份证号码，如何转换？则只需用将Response.Write(@"<style>td”)格式中的mso-number-format:General;改变成mso-number-format:\@; 即可实现。

protected void btnExport_Click(object sender, EventArgs e)
        {

            Response.Clear();
            Response.ClearContent();
            Response.ClearHeaders();
            Response.AddHeader("content-disposition", "attachment; filename=IBLAC_Question_Report.xls");
            Response.ContentEncoding = System.Text.Encoding.Unicode;
            Response.ContentType = "application/ms-excel";
            Response.BinaryWrite(System.Text.Encoding.Unicode.GetPreamble());

            System.Text.StringBuilder sbTotal = new StringBuilder();
            string strQuestionReportName = "QuestionReportName";
            string strQuestionReporterName = "QuestionReporterByName";
            string strQuestionReporterCompanyName = "QuestionReporterCompanyName";
            sbTotal.AppendLine(string.Format("<tr><th>{0}</th><th>{1}</th><th>{2}</th></tr>", strQuestionReportName, strQuestionReporterName, strQuestionReporterCompanyName));
//上面定义excel行标题
            StringBuilder sb = new StringBuilder();

            try
            {
                foreach (DataRow dr in objQustionReport.Rows)
                {
                    sb = new StringBuilder();
                    sb.Append("<tr>");
                    sb.AppendFormat("<td>{0}</td>", HttpUtility.HtmlDecode(Convert.ToString(dr["QuestionDetial"])));
                    sb.AppendFormat("<td>{0}</td>", HttpUtility.HtmlDecode((new ListOperations()).getCurrentUserDisplayName(Convert.ToString(dr["QuestionUserID"]))));
                    sb.AppendFormat("<td>{0}</td>", HttpUtility.HtmlDecode(Convert.ToString(dr["QuestionCompanyName"])));
                    sb.Append("</tr>");
                    sbTotal.AppendLine(sb.ToString());
                }

                Response.Write("<html><head><meta http-equiv=\"content-type\" content=\"application/ms-excel; charset=UTF-8\">");
                Response.Write(@"<style>
td
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:black;
	font-size:10.0pt;
	font-weight:400;
	font-style:normal;
	text-decoration:none;
	font-family:Calibri, sans-serif;
	mso-font-charset:134;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	border:.5pt solid windowtext;
	mso-background-source:auto;
	mso-pattern:auto;
	white-space:normal;}
th
	{padding-top:1px;
	padding-right:1px;
	padding-left:1px;
	mso-ignore:padding;
	color:white;
	font-size:10.0pt;
	font-weight:700;
	font-style:normal;
	text-decoration:none;
	font-family:Calibri, sans-serif;
	mso-font-charset:0;
	mso-number-format:General;
	text-align:general;
	vertical-align:bottom;
	border:.5pt solid windowtext;
	background:#366092;
	mso-pattern:black none;
	white-space:normal;}

</style>");


                Response.Write("</head><body><table border=0 cellpadding=0 cellspacing=0 style='border-collapse: collapse;table-layout:fixed;'>");
                Response.Write(sbTotal.ToString());
                Response.Write("</table></body></html>");
                Response.Flush();
            }
            catch (Exception ex)
            {

                SPDiagnosticsService.Local.WriteTrace(0, new SPDiagnosticsCategory("  Send Mail Web Part", TraceSeverity.Unexpected, EventSeverity.ErrorCritical), TraceSeverity.Unexpected, ex.Message, ex.StackTrace);

                string error = string.Format("javascript:alert('{0}');", "Application error occurred, please contact system administrator.");

                this.Page.ClientScript.RegisterStartupScript(this.GetType(), "Error Message", error, true);
            }


        }
    }
}

注意：此两种方法在.net中将gridview导出到execl是没有问题的，但是在sharepoint中只能导出一次，如果重复导出操作，将会无效，如何修复此种bug？只需在后台添加如下两行代码。

在Page_Load方法上面添加：

private static string script= "_spOriginalFormAction =document.forms[0].action;\n_spSuppressFormOnSubmitWrapper = true;";

在Page_Load方法里面添加，注意不要将下面代码添加到IsPostBack里面：

Page.ClientScript.RegisterStartupScript(this.GetType(), Guid.NewGuid().ToString(),script, true);

希望对从事sharepoint开发的朋友有所帮助