怎么设定GridView导出EXECL字体的大小

Question

  GridView导出EXECL的代码为 
 protected void TDAddButton2_Click(object sender, EventArgs e)
    {
       
            this.GridView1.Columns[6].Visible = false;
            Response.Clear();
            Response.AddHeader("content-disposition", "attachment;filename=FileName.xls");
            Response.Charset = "gb2312";
            Response.ContentType = "application/vnd.xls";
            System.IO.StringWriter stringWrite = new System.IO.StringWriter();
            System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);            GridView1.AllowPaging = false;
            bind();
            GridView1.RenderControl(htmlWrite);            Response.Write(stringWrite.ToString());
            Response.End();
            GridView1.AllowPaging = true;
            this.GridView1.Columns[6].Visible = true;
            bind();
        
       
    }
导出来后EXECL的字体太小，怎么在程序里设定导出到EXECL里字体的大小，请高手指教

Answer 1

//设置字体大小
        xlsheet.get_Range(xlsheet.Cells[1, 1], xlsheet.Cells[1, _col]).Font.set_Size(14);

Answer 2

建议你把导出的Excel的格式写个方法。
生成EXCEL文件
    /// _til是表格的标题，_row是表格的行数,_col是表格的列数,_dt是数据表,。

Answer 3

xlsheetS 是从哪里得来的