dataGird导出到EXCEL的问题

Question

我的代码如下：
DataTable dt = ((DataSet)dataGrid1.DataSource).Tables[table_name];
object oMissing = Type.Missing;
string FileName="c:\\address.xls";
long totalCount=dt.Rows.Count;
long rowRead=0;
float percent=0;
Excel.Application xlApp=null;
xlApp=new Excel.Application();
Excel.Workbooks workbooks=xlApp.Workbooks;
Excel.Workbook workbook=workbooks.Add(Excel.XlWBATemplate.xlWBATWorksheet);
workbook= xlApp.Workbooks.Open(FileName,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing,oMissing);
Excel.Worksheet worksheet=(Excel.Worksheet)workbook.Worksheets[1];//取得sheet1
Excel.Range range;

worksheet.Cells[1,1]="所属部门";
worksheet.Cells[1,2]="职位名称";
worksheet.Cells[1,3]="员工姓名"; for(int r=0;r<dt.Rows.Count;r++)
{
DataRow dr = dt.Rows[r];
worksheet.Cells[r+2,1]=dt.Rows[r][0].ToString();
worksheet.Cells[r+2,2]=dt.Rows[r][1].ToString();
worksheet.Cells[r+2,3]=dt.Rows[r][2].ToString();
rowRead++;
percent=((float)(100*rowRead))/totalCount;   
}
range=worksheet.get_Range(worksheet.Cells[1,1],worksheet.Cells[dt.Rows.Count+2,dt.Columns.Count]);
workbook.Saved =true;
怎么我的这段代码就是导出不到EXCEL呢？？
EXCEL的进程都是打开了的，又没有提示那里出错，请问是那里原因
那位高手帮帮忙！！！！！！！
谢谢了！！！！！！！

Answer 1

给你一段代码，自己看吧。
private void creatExcel()
{
int i=2,j;
Excel.Application excel = new Excel.ApplicationClass();
excel.DefaultFilePath   = record_defaultpath; Excel.Workbook workbook = excel.Workbooks.Add(Type.Missing);
excel.Cells[1,1]="码";
excel.Cells[1,2]="名";
excel.Cells[1,3]="时间";
excel.Cells[1,4]="位()";
excel.Cells[1,5]="量()";
excel.Cells[1,6]="降()";
foreach(DataRow dr in ds.Tables["check"].Rows)
{
for (j=1;j<=6;j++)
{
excel.Cells[i,j] = dr[j-1] ;
    }
i++;
}
workbook.SaveAs(this.currentTime.ToShortDateString(),Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Excel.XlSaveAsAccessMode.xlNoChange,Type.Missing,Type.Missing,Type.Missing,Type.Missing);
workbook.Close(false,Type.Missing,Type.Missing);
}

Answer 2

lz参考一下这个：http://book.chinaz.com/others/jishidaquan/17/40337.html