datagrid 导入 excel 问题

Question

private void Button1_Click(object sender, System.EventArgs e) 
{ 
if(TextBox1.Text=="") 
{ 
Response.Write("<SCRIPT language=javascript>"); 
Response.Write("window.alert(''请输入文件名'');"); 
Response.Write("</SCRIPT>"); 
} 
else 
{ 
Response.Clear(); 
Response.Buffer= true; 
Response.Charset="GB2312"; //设置了类型为中文防止乱码的出现 
Response.AppendHeader("Content-Disposition","attachment;filename="+TextBox1.Text+".xls"); //定义输出文件和文件名 
Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312");//设置输出流为简体中文 
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。 
this.EnableViewState = false; 
System.Globalization.CultureInfo myCItrad = new System.Globalization.CultureInfo("ZH-CN",true); 
System.IO.StringWriter oStringWriter = new System.IO.StringWriter(myCItrad); 
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter); 
this.DataGrid1.RenderControl(oHtmlTextWriter); 
Response.Write(oStringWriter.ToString()); 
} 
} 
这段代码 是把datagrid 导入 excel中
现在有一个问题
问什么导入后excel表中第一行空白！！
谢谢！！！！！！！！

Answer 1

excel的SHEET单元的第一行是标题行吧，你要自己做处理。

Answer 2

StringWriter tw=new StringWriter();
HtmlTextWriter hw=new HtmlTextWriter(tw);
grd.RenderControl(hw);
int intV;
string  strFileName;
Random rd=new Random();
intV=rd.Next();
strFileName=DateTime.Now.Second.ToString()+DateTime.Now.Millisecond.ToString()+intV.ToString()+".xls";
string filenew=Page.MapPath("../uploading/"+strFileName);
FileStream fl=new FileStream(filenew,FileMode.CreateNew);
StreamWriter fw=new StreamWriter(fl,System.Text.Encoding.GetEncoding("GB2312"));
fw.WriteLine(tw.ToString());
fw.Close();
fl.Close();
string strScript = "<script language=javascript> window.open('../uploading/" + strFileName + "', '', 'left=50,top=50,resizable=1,scrollbars=1,width=500,height=400,menubar=1'); </script>";
Page.RegisterStartupScript("", strScript);

Answer 3

private void BtnExport_Click(object sender, System.EventArgs e)
        {
            StringWriter sw=new StringWriter(); 
            sw.WriteLine("所属库房\t类别名称\t号码段\t开始序号\t结尾序号\t库存状态"); 
            dt=(System.Data.DataTable)Session["SmnoStock"];
            DataRow dr;
            string housename,sortname,smno,fromno,tono,stock;
            for(int i=0;i<dt.Rows.Count;i++)
            { 
                dr=dt.Rows[i];
                housename=dr["housename"].ToString();
                sortname=dr["sortname"].ToString();
                smno=dr["smno"].ToString();
                fromno=dr["fromno"].ToString();
                tono=dr["tono"].ToString();
                stock=dr["stock"].ToString();
                sw.WriteLine(housename+"\t"+sortname+"\t"+smno+"\t"+fromno+"\t"+tono+"\t"+stock); 
            }             sw.Close();
            Response.AddHeader("Content-Disposition", "attachment; filename=sm"+DateTime.Now.ToShortDateString()+".xls"); 
            Response.ContentType = "application/ms-excel"; 
            Response.ContentEncoding=System.Text.Encoding.GetEncoding("GB2312"); 
            Response.Write(sw); 
            Response.End();
        }