Question

asp.net 文件流导出EXCEL无数据的地方为空白

请问如何解决asp.net 文件流导出EXCEL无数据的地方为空白（单元格没有边框）,我的代码如下：
dt为数据源，
GridView gvExcel = new GridView();
gvExcel.DataSource = dt;
gvExcel.DataBind();
gvExcel.Attributes.Add("style", "vnd.ms-excel.numberformat:@");
Response.ClearContent();
//Response.AddHeader("content-disposition", "attachment; filename=Excel.xls");
string fileName = "问题管理" + DateTime.Now.ToString("yyyyMMddHHmm");
Response.Clear();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Write("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>");
Response.AddHeader("content-disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8) + ".xls");
//Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-7"); //防止导出表格标题乱码
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gvExcel.RenderControl(htw);
//Response.Write(sw.ToString().Replace("border=\"0\"", "border=\"1\"").Replace("href='#'", "").Replace("color:white;", "color:black"));
Response.Write(sw.ToString());
Response.End();
谢了！

Answer 1

自己改吧。全选中，单元格设置，取消边框。
选中有内容的部分，单元格设置，设置边框，是否加粗边框

Answer 2

导出html的，然后把扩展名改成xls

追问

扩展名是XLS的