将table 导入到Excel中,我导入的格式总是不默认的html格式。我想自动默认未.xls格式我的代码如下
string filename="";
Response.Clear();
Response.Buffer= true;Response.Charset="GB2312";

 filename="Query.xls";

Response.AppendHeader("Content-Disposition","attachment;filename="+ filename +"");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");Response.ContentType = "application/ms-excel";
this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.Table1.RenderControl(oHtmlTextWriter);           
Response.Write(oStringWriter.ToString());
 Response.End();还有怎样设置默认的字体啊!!!要求是Excel中文字字体需设为Arial,大小为10
各位大侠帮忙解决一下!!!谢谢!