以下这段是将GirdView的数据导出到Excel的代码，，在网上查到的。初学，不知道前后应如何补充使其完整，，求高手帮我补充一下。
 this.GridView1.DataBind();

    Excel.ApplicationClass oExcel = new Excel.ApplicationClass();
   object oMissing  = System.Reflection.Missing.Value;
            
   oExcel.Workbooks.Add(oMissing);
   Excel.Workbook oBook = oExcel.Workbooks[1];
   Excel.Worksheet oSheet = (Excel.Worksheet)oBook.Sheets[1];
   oSheet.Name = this.Title;
           
   Excel.Range rg;

   for (int j = 0; j < this.GridView1.HeaderRow.Cells.Count; j++)
  {
      rg = ((Excel.Range)oSheet.Cells[ 1, j + 1]);
      rg.FormulaR1C1 = this.GridView1.HeaderRow.Cells[j].Text;
    }

    for(int i = 0;i<this.GridView1.Rows.Count;i++)
  {
      for (int j = 0; j < this.GridView1.Rows[0].Cells.Count; j++)
    {
       rg = ((Excel.Range)oSheet.Cells[i + 2, j+1]);
       rg.FormulaR1C1 = this.GridView1.Rows[i].Cells[j].Text;
      }
    }
    rg = null;

    string VirFileName = Guid.NewGuid().ToString() + ".xls";
    oBook.SaveAs(Server.MapPath(VirFileName), Excel.XlFileFormat.xlExcel9795, oMissing, oMissing, oMissing, oMissing, Excel.XlSaveAsAccessMode.xlExclusive,
    oMissing, oMissing, oMissing, oMissing, oMissing);
    oExcel.Workbooks.Close();
    oExcel.Quit();
           
    oSheet = null;
    oBook = null;
    oExcel = null;

     GC.Collect();

     Response.Redirect(VirFileName);

送楼主参考一下吧。

 public void DataExcelResult()
        {
            string str = null;
            string tempStr = null;
            try
            {
                if (saveFileDialog.ShowDialog() == DialogResult.Cancel)
                    return;

                Stream myStream = saveFileDialog.OpenFile();
                StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding("gb2312")); //gb2312

                try
                {
                    //写标题
                    for (int i = 0; i < dataGridPlay.ColumnCount; i++)
                    {
                        str += dataGridPlay.Columns[i].HeaderText;
                        if (i >=0)  
                        {
                            str += "\t";
                        }           
                    }

                    sw.WriteLine(str);
                    //写内容

                    for (int j = 0; j < dataGridPlay.Rows.Count - 1; j++)
                    {
                        tempStr = "";

                        for (int k = 0; k < dataGridPlay.Columns.Count; k++)
                        {
                            tempStr += dataGridPlay.Rows[j].Cells[k].Value.ToString();

                            if (k >= 0)         
                            {
                                tempStr += "\t";
                            }
                        }
                        sw.WriteLine(tempStr);
                    }
                    sw.Close();
                    myStream.Close();
                    MessageBox.Show("恭喜你，导出成功","导出信息");
                }
                catch (Exception ex)
                {
                    MessageBox.Show("写入出错" + ex.ToString());
                }
                finally
                {
                    sw.Close();
                    myStream.Close();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("你的格式错误。。如。。*.xls或*.txt或*.doc" + ex.ToString());
            }
        }