open excel file on the webserver

C

cathiec

Active member
Joined
Mar 8, 2004
Messages
28
i am using an add-on component called eXport.net to export data to an excel worksheet. the sheet must first be saved on the webserver before naything can be done with it. i then include some inline javascript to open the excel spresdsheet in a new window. everything works fine up until the opening of the file in a new window. the file is created on the webserver but will not open up in a new browser window for me. below is the code i am using:

SqlDataAdapter da;
DataSet ds;
ds = new DataSet();
da = new SqlDataAdapter("stpDEBgetInsuranceMailMerge", strConnection);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.Fill(ds, "SSRFADD");


eXportNET SF = new eXportNET();
String strFileName;
StringBuilder sb = new StringBuilder();
SF.FileType = "XLS";
SF.SavePath = Server.MapPath("");
strFileName = SF.CreateFileFromDataset(ds);
strFileName = strFileName.Substring(strFileName.LastIndexOf("\\")+1);

sb.Append("<SCRIPT>");
sb.Append("window.open(" + strFileName + ");");
sb.Append("</SCRIPT>");
Response.Write(sb.ToString());


this works from within visual studio when i build and browse but the minute i copy and paste the link into a browser window and click on Export Report button i get the file is created but nothing happens -(no window opended up showing the file)
 
Back
Top