When this report opens in either the browser or Excel it opens in the same window as the web application that it was running from. There is no back button available and no way to get back to the orginial web application.
How can I get this workbook to open in a new window?
DataTable dataTable = (DataTable)Session["SearchResults"];
Aspose.Cells.License license = new Aspose.Cells.License();
license.SetLicense("Aspose.Total.lic");
//Request.ApplicationPath as it returns a "/" when at the root but not when in a vitural directory
string sPath = Server.MapPath(HttpContext.Current.Request.ApplicationPath);
if (sPath.Substring(sPath.Length -1,1) != "\\")
sPath = sPath + "\\";
string sFile = sPath + "GamReporting.xls";
Workbook workbook = new Workbook();
workbook.Open(sFile);
Worksheet sheet = workbook.Worksheets[0];
int rc;
rc = sheet.Cells.ImportDataView(dataTable.DefaultView, true, 0, 0, true);
workbook.Save("GAMReporting.xls" + System.DateTime.Now.ToString(), FileFormatType.Default, SaveType.OpenInBrowser, Response);