C#导出Excel 为什么 12-15 变成12月15了

Question

要看GetGridTableHtml的代码
  
*****************************************************************************
签名档： http://feiyun0112.cnblogs.com/

Answer 1

private string GetGridTableHtml(DataTable dt)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("<table cellspacing=\"0\" rules=\"all\" border=\"1\" style=\"border-collapse:collapse;\">");
            sb.Append("<tr>");
            foreach (DataColumn column in dt.Columns)
            {
                sb.AppendFormat("<td>{0}</td>", column.ColumnName);
            }
            sb.Append("</tr>");
            foreach (DataRow row in dt.Rows)
            {
                sb.Append("<tr>");
                foreach (object value in row.ItemArray)
                {
                    string html = value.ToString();
                    // 处理CheckBox
                    if (html.Contains("box-grid-static-checkbox"))
                    {
                        if (html.Contains("box-grid-static-checkbox-uncheck"))
                        {
                            html = "×";
                        }
                        else
                        {
                            html = "√";
                        }
                    }                    // 处理图片
                    if (html.Contains("<img"))
                    {
                        string prefix = Request.Url.AbsoluteUri.Replace(Request.Url.AbsolutePath, "");
                        html = html.Replace("src=\"", "src=\"" + prefix);
                    }                    sb.AppendFormat("<td>{0}</td>", html);
                }
                sb.Append("</tr>");
            }            sb.Append("</table>");            return sb.ToString();
        }

Answer 2

同意楼上的。但是你table里是12-15这一列不应该是时间类型啊。还是要看一下GetGridTableHtml