求教一个关于Excel导出的问题

FallenChen_ 2012-09-13 02:21:06

protected void btnExcel_Click(object sender, EventArgs e)
{
DataTable dt = getExcelData();
if (dt.Rows.Count > 0)
{
string nus = Server.MapPath("../upload_data/Excel/员工通迅录.xls");
DataTableToExcel(dt, nus, "baohe");
btnExcel.Visible = false;
xiazai.Visible = true;
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('目前没有数据')</script>");
}
}
/// <summary>
/// 将指定的DataTable的数据写入Excel
/// </summary>
/// <param name="table">要导出的数据集合</param>
/// <param name="fileName">要创建的文件名</param>
/// <returns>返回文件保存是否成功</returns>
public static void DataTableToExcel(DataTable table, string fileName, string tmpfile)
{
Excel.Application app = new Excel.ApplicationClass();
try
{
app.Visible = false; //表明Excel应用程序不可见
Excel.Workbook wBook = app.Workbooks.Add(Type.Missing);//创建一个新的Excel文件
Excel.Worksheet wSheet = wBook.Worksheets[1] as Excel.Worksheet;
//写入列名
for (int i = 0; i < table.Columns.Count; i++)
{
wSheet.Cells[1, 1 + i] = table.Columns[i].ColumnName;
}
//写入数据
if (table.Rows.Count > 0)
{
for (int i = 0; i < table.Rows.Count; i++)
{
for (int j = 0; j < table.Columns.Count; j++)
{
wSheet.Cells[i + 2, j + 1] = table.Rows[i][j].ToString();
}
}
}
//设置禁止弹出保存和覆盖的询问提示框
app.DisplayAlerts = false;
app.AlertBeforeOverwriting = false;
//保存模板文件
wBook.SaveAs(tmpfile, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Excel.XlSaveAsAccessMode.xlShared, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
//保存excel文件
app.Save(fileName);
app.SaveWorkspace(fileName);
wBook.Close(null, null, null);//必不可少的，若没关闭它,等于一直打开着该工作薄的,就谈不上关闭进程了
app.Workbooks.Close();
app.Quit();
int generation = GC.GetGeneration(app);
app = null;
System.GC.Collect(generation);
}
catch (Exception err)
{
throw err;
}
}

这是2个方法将查询到的数据转换为Excel保存到项目upload_data/Excel文件夹下然后用<A>链接下载到本地，可以下载后打开发现里面的数据不是服务器中数据库的数据而是本地的数据？这是什么情况？怎么解决？

...全文