When i run this code in local site it's working. but in a server site sometimes it's showing error(The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)) -
sheet.Cells[i + 3, 1] = dsRides.Tables[0].Rows[i]["APPDate"].ToString().Trim(); sheet.Cells[i + 3, 2] = dsRides.Tables[0].Rows[i]["Appnum"].ToString().Trim(); sheet.Cells[i + 3, 3] = dsRides.Tables[0].Rows[i]["sendTripId"].ToString().Trim(); sheet.Cells[i + 3, 4] = dsRides.Tables[0].Rows[i]["DriverName"].ToString().Trim(); sheet.Cells[i + 3, 5] = dsRides.Tables[0].Rows[i]["Custname"].ToString().Trim(); sheet.Cells[i + 3, 6] = dsRides.Tables[0].Rows[i]["PickupTime"].ToString().Trim(); sheet.Cells[i + 3, 7] = dsRides.Tables[0].Rows[i]["StartTime"].ToString().Trim(); sheet.Cells[i + 3, 8] = dsRides.Tables[0].Rows[i]["startLoc"].ToString().Trim(); sheet.Cells[i + 3, 9] = dsRides.Tables[0].Rows[i]["ActPickAddress"].ToString().Trim(); sheet.Cells[i + 3, 10] = dsRides.Tables[0].Rows[i]["startLocDiff"].ToString().Trim(); sheet.Cells[i + 3, 11] = dsRides.Tables[0].Rows[i]["AppTime"].ToString().Trim(); ; sheet.Cells[i + 3, 12] = dsRides.Tables[0].Rows[i]["stoptime"].ToString().Trim(); sheet.Cells[i + 3, 13] = dsRides.Tables[0].Rows[i]["stopLoc"].ToString().Trim(); sheet.Cells[i + 3, 14] = dsRides.Tables[0].Rows[i]["ActDropAddress"].ToString().Trim(); sheet.Cells[i + 3, 15] = dsRides.Tables[0].Rows[i]["StopLocDiff"].ToString().Trim(); sheet.Cells[i + 3, 16] = dsRides.Tables[0].Rows[i]["Mileage"].ToString().Trim(); sheet.Cells[i + 3, 17] = totoalhor; } if (File.Exists(Server.MapPath("TempReports/") + "RideAnalysis.xls")) { File.Delete(Server.MapPath("TempReports/") + "RideAnalysis.xls"); } wb.SaveAs(Server.MapPath("TempReports/") + "RideAnalysis.xls", XlFileFormat.xlXMLSpreadsheet, Type.Missing, Type.Missing, false, false, XlSaveAsAccessMode.xlNoChange, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); wb.Close(null, null, null); xlApp.Quit();
Response.ClearContent();
Response.ClearHeaders();
Response.AddHeader("Content-Disposition", "Attachment;Filename=RideAnalysis.xls");
Response.ContentType = "application/vnd.ms-excel";
Response.WriteFile(Server.MapPath("TempReports/") + "RideAnalysis.xls");
Response.Flush();
Response.End();
Response.Close();
User contributions licensed under CC BY-SA 3.0