使用visual studio 2008开发ASP.NET程序,导出excel文档,调试过程能生成excel文件,发布后点导出按钮不起任何作用 . 检查代码后发现是ApplicationClass app=new ApplicationClass();操作出现问题,发布后的程序运行到这行就不继续运行了,换成Application app=new Application();也是一样的问题,Excel包使用的是11.0的。知道的朋友帮帮忙。
代码如下:
using System.IO;
using Microsoft.Office.Interop.Excel;
private void ImportExcel()
{
Boolean check911 = false;
ApplicationClass excelApp;
object missing = System.Reflection.Missing.Value;
Workbook NewWorkBook;
Worksheet NewSheet;
Range cell = null;
System.GC.Collect();
excelApp = new ApplicationClass();
string MbxlsPath = this.Request.PhysicalApplicationPath + @"Reports\a.xls";
string ScxlsPath = this.Request.PhysicalApplicationPath + @"Reports\b.xls";
NewWorkBook = excelApp.Workbooks.Open(MbxlsPath, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing);
NewSheet = (Worksheet)NewWorkBook.Sheets[1];
string cellStrbt = "";
cell = NewSheet.get_Range("A" + "1", missing);
cellStrbt = this.TreeJGID.Value + cell.Value2.ToString();
cell.set_Value(missing, cellStrbt); cell = NewSheet.get_Range("H" + "2", missing);
cellStrbt = this.TextBoxQZSJMIN.Text + "至" + this.TextBoxQZSJMAX.Text;
cell.set_Value(missing, cellStrbt);
if (System.IO.File.Exists(ScxlsPath))
{
System.IO.File.Delete(ScxlsPath);
}
NewSheet.SaveAs(ScxlsPath, XlFileFormat.xlExcel9795,
missing, missing, true, missing, true, missing, missing, missing);
}
NewWorkBook.Close(false, missing, missing);
excelApp.Quit();
cell = null;
NewSheet = null;
NewWorkBook = null;
excelApp = null;
System.GC.Collect();
string script;//= "<script type=\"text/javascript\">\n" +
// "<!--\n" +
script = "window.open(\"../Reports/a.xls\");\n";// +
// "-->\n" +
// "</script>";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), this.RegisterKey, script, true);
}
代码如下:
using System.IO;
using Microsoft.Office.Interop.Excel;
private void ImportExcel()
{
Boolean check911 = false;
ApplicationClass excelApp;
object missing = System.Reflection.Missing.Value;
Workbook NewWorkBook;
Worksheet NewSheet;
Range cell = null;
System.GC.Collect();
excelApp = new ApplicationClass();
string MbxlsPath = this.Request.PhysicalApplicationPath + @"Reports\a.xls";
string ScxlsPath = this.Request.PhysicalApplicationPath + @"Reports\b.xls";
NewWorkBook = excelApp.Workbooks.Open(MbxlsPath, missing, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing);
NewSheet = (Worksheet)NewWorkBook.Sheets[1];
string cellStrbt = "";
cell = NewSheet.get_Range("A" + "1", missing);
cellStrbt = this.TreeJGID.Value + cell.Value2.ToString();
cell.set_Value(missing, cellStrbt); cell = NewSheet.get_Range("H" + "2", missing);
cellStrbt = this.TextBoxQZSJMIN.Text + "至" + this.TextBoxQZSJMAX.Text;
cell.set_Value(missing, cellStrbt);
if (System.IO.File.Exists(ScxlsPath))
{
System.IO.File.Delete(ScxlsPath);
}
NewSheet.SaveAs(ScxlsPath, XlFileFormat.xlExcel9795,
missing, missing, true, missing, true, missing, missing, missing);
}
NewWorkBook.Close(false, missing, missing);
excelApp.Quit();
cell = null;
NewSheet = null;
NewWorkBook = null;
excelApp = null;
System.GC.Collect();
string script;//= "<script type=\"text/javascript\">\n" +
// "<!--\n" +
script = "window.open(\"../Reports/a.xls\");\n";// +
// "-->\n" +
// "</script>";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), this.RegisterKey, script, true);
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货