===============高分求asp.net导出excel后无法远程访问问题==========================

thbird 2007-01-19 10:49:18

问题是这样的: 在asp.net中,把dataTable中的数据导入到excel. 目前本地已经测试没有问题,但局域网中的其它机子访问导出后的excel文件时,没有任何反映. 我已经设置了文件目录everyone读写权限. 以及在Dcom配置中的excel应用程序的"启动和激活权限" "访问权限" 给于了everyone所有的权限.

Excel.ApplicationClass myApp;
Excel.Workbook myBook;
Excel.Worksheet mySheet;

string tableName = "mp_ZZFY";
string FilePath = Server.MapPath(tableName); //模板文件路径

myApp = null;
myBook = null;
mySheet = null;

object oMissiong = System.Reflection.Missing.Value;

myApp = new Excel.ApplicationClass();

myApp.Visible = false;

myApp.Workbooks.Open(FilePath, oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong,oMissiong);

myBook=myApp.Workbooks[1];

mySheet=(Excel.Worksheet)myBook.ActiveSheet;

#region 一个萝卜一个坑
mySheet.Cells[i,j] = DataTable中的数据;
.......
#endregion

myBook.Save();

myBook.Close(true,FilePath,true);

//myApp.Quit();

System.Runtime.InteropServices.Marshal.ReleaseComObject(mySheet);

System.Runtime.InteropServices.Marshal.ReleaseComObject(myBook);

System.Runtime.InteropServices.Marshal.ReleaseComObject(myApp);

GC.Collect();
#endregion

Response.Redirect(FilePath);

...全文

339 10 打赏收藏转发到动态举报

写回复

用AI写文章

10 条回复

切换为时间正序

请发表友善的回复…

发表回复

guguniu 2009-10-04

打赏
举报

shidan520 2008-09-19

打赏
举报

现在都没有人解决吗?我也碰到了类似问题!

九章落地 2007-01-20

打赏
举报

樓主在Response.Redirect(FilePath);這條語句設個斷點，看看路徑是否正確。

thbird 2007-01-19

打赏
举报

Response.Redirect(FilePath);

zht1009 2007-01-19

打赏
举报

你是怎么访问的?

广州人 2007-01-19

打赏
举报

给你另外一条思路
private void btnMIME_Click(object sender, System.EventArgs e)
{
BindData();

Response.ContentType = "application/vnd.ms-excel";
Response.AddHeader("Content-Disposition", "inline;filename="
+ HttpUtility.UrlEncode("下载文件.xls",Encoding.UTF8 ) );

//如果输出为Word，修改为以下代码
//Response.ContentType = "application/ms-word"
//Response.AddHeader("Content-Disposition", "inline;filename=test.doc")
StringBuilder sb=new StringBuilder();
System.IO.StringWriter sw = new System.IO.StringWriter(sb);
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw);
sb.Append("<html><body>");
dgShow.RenderControl(hw);
sb.Append("</body></html>");
Response.Write(sb.ToString());
Response.End();
}

private DataSet BindData()
{
SqlConnection myConnection = new SqlConnection( "server=(local);uid=sa;pwd=111;database=Pubs" );
DataSet myDataSet = new DataSet();
SqlDataAdapter myDataAdapter = new SqlDataAdapter("Select * From Authors", myConnection );
myDataAdapter.Fill( myDataSet, "Authors" );
dgShow.DataSource = myDataSet.Tables[0].DefaultView;
dgShow.DataBind();
return myDataSet;

}