Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
13
Reply
Export Excel not working in Server
Hareesh Bollepalli
Aug 17 2015 2:35 AM
771
Reply
Hello All,
I am working with Excel. i have a an issue if i export to excel in local Machine it's working fine when i Deploy in server it's not working i got an error like Request failed.
Here is my code:
public JsonResult ExportEMCTSReleaseDetails()
{
Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
try
{
Excel.Workbook xlWb;
Excel.Worksheet xlWs;
long lnRelease = 0;
int iRevision;
string strHeader = string.Empty;
string strEMCTSRelease = string.Empty;
string strShtName = string.Empty;
string strProject = string.Empty;
string strDesign = string.Empty;
string strDRevision = string.Empty;
for (int j = 0; j < SearchRecords.Count(); j++)
{
if (SearchRecords[j].Comments == "History Starts")
{
SearchRecords.RemoveRange(j, SearchRecords.Count() - j);
break;
}
}
xlApp.SheetsInNewWorkbook = SearchRecords.Count();
xlWb = xlApp.Workbooks.Add();
List<IndexEmctestSetup> RelDetailsSearchRecords = new List<IndexEmctestSetup>();
int r;
for (int i = 0; i < SearchRecords.Count(); i++)
{
lnRelease = SearchRecords[i].ReleaseID;
iRevision = (int)SearchRecords[i].Revision;
RelDetailsSearchRecords = null;
RelDetailsSearchRecords = GetEMCTSReleaseVersionRecords(lnRelease, iRevision);
r = 5;
xlWs = xlWb.Worksheets.get_Item(i + 1);
RelDetailsSearchRecords.ForEach(delegate(IndexEmctestSetup e)
{
strEMCTSRelease = e.ReleaseName;
strProject = e.Project;
xlWs.Cells[r, 1] = e.ReleaseName + " - " + e.ReleaseRevision;
strShtName = e.ReleaseName + " - " + e.ReleaseRevision;
xlWs.Cells[r, 2] = e.Project;
xlWs.Cells[r, 3] = e.ECSEMCTestSetupId + " - " + e.Revision;
xlWs.Cells[r, 4] = e.ECSSuitcaseTesterId;
xlWs.Cells[r, 5] = e.ECSSuitcaseControllerId;
xlWs.Cells[r, 6] = e.ECSEMCLoadBoxId;
xlWs.Cells[r, 7] = e.ECSEMCModuleId;
xlWs.Cells[r, 8] = e.HarnessId;
xlWs.Cells[r, 9] = (!string.IsNullOrEmpty(e.DataCollector)) && (e.DataCollector != clsLists.NA) ? e.DataCollector : clsLists.NA;
xlWs.Cells[r, 10] = (!string.IsNullOrEmpty(e.TriggerBox)) && (e.TriggerBox != clsLists.NA) ? e.TriggerBox : clsLists.NA;
xlWs.Cells[r, 11] = e.Location;
xlWs.Cells[r, 12] = e.Disposition;
xlWs.Cells[r, 13] = e.Comments;
r++;
});
strHeader = "EMCTestSetup Release \"" + strShtName + "\" Exported on: " + System.DateTime.Now.ToString() + " by \"" + clsLists.getCurrentUserEmail() + "\"";
project pr = ReleaseEMCTSDB.projects.Where(x => x.ProjectName == strProject).FirstOrDefault();
platform pf = ReleaseEMCTSDB.platforms.Where(x => x.PlatformId == pr.Platform_Proj).FirstOrDefault();
strProject = "Project: " + strProject + "(" + pr.ProjectDescription + ")";
releasesemctestsetup rel = ReleaseEMCTSDB.releasesemctestsetups.Where(m => m.ReleaseName == strEMCTSRelease).FirstOrDefault();
strDesign = "Release Design: " + clsLists.getDesigns().Find(x => x.Value == rel.Design).Text;
strDRevision = "Release Design Revision: " + rel.DesignRevision.ToString();
xlWs.Cells[1, 1] = strHeader;
xlWs.Cells[2, 1] = strProject;
xlWs.Cells[3, 1] = strDesign;
xlWs.Cells[3, Convert.ToInt32(clsLists.getEMCTSReleaseDetailsExportParamList().Count / 2)] = strDRevision;
int col = 1;
clsLists.getEMCTSReleaseDetailsExportParamList().ForEach(delegate(string strParam)
{
xlWs.Cells[4, col] = strParam;
col++;
});
xlWs.Name = strShtName;
Excel.Range rng;
rng = xlWs.get_Range((Excel.Range)xlWs.Cells[1, 1], (Excel.Range)xlWs.Cells[1, clsLists.getEMCTSReleaseDetailsExportParamList().Count]);
rng.Merge(Missing.Value);
rng.EntireRow.Font.Bold = true;
rng = xlWs.get_Range((Excel.Range)xlWs.Cells[2, 1], (Excel.Range)xlWs.Cells[2, Convert.ToInt32(clsLists.getEMCTSReleaseDetailsExportParamList().Count / 2) - 1]);
rng.Merge(Missing.Value);
rng.EntireRow.Font.Bold = true;
rng = xlWs.get_Range((Excel.Range)xlWs.Cells[2, Convert.ToInt32(clsLists.getEMCTSReleaseDetailsExportParamList().Count / 2)], (Excel.Range)xlWs.Cells[2, clsLists.getEMCTSReleaseDetailsExportParamList().Count]);
rng.Merge(Missing.Value);
rng.EntireRow.Font.Bold = true;
rng = xlWs.get_Range((Excel.Range)xlWs.Cells[3, 1], (Excel.Range)xlWs.Cells[3, Convert.ToInt32(clsLists.getEMCTSReleaseDetailsExportParamList().Count / 2) - 1]);
rng.Merge(Missing.Value);
rng.EntireRow.Font.Bold = true;
rng = xlWs.get_Range((Excel.Range)xlWs.Cells[3, Convert.ToInt32(clsLists.getEMCTSReleaseDetailsExportParamList().Count / 2)], (Excel.Range)xlWs.Cells[3, clsLists.getEMCTSReleaseDetailsExportParamList().Count]);
rng.Merge(Missing.Value);
rng.EntireRow.Font.Bold = true;
rng = xlWs.get_Range((Excel.Range)xlWs.Cells[4, 1], (Excel.Range)xlWs.Cells[4, clsLists.getEMCTSReleaseDetailsExportParamList().Count]);
rng.EntireRow.Font.Bold = true;
rng.Interior.Color = Excel.XlRgbColor.rgbLightSteelBlue;
rng = xlWs.get_Range((Excel.Range)xlWs.Cells[1, 1], (Excel.Range)xlWs.Cells[xlWs.UsedRange.Rows.Count, clsLists.getEMCTSReleaseDetailsExportParamList().Count]);
rng.Borders[Excel.XlBordersIndex.xlEdgeBottom].Color = Color.Blue.ToArgb();
rng.Borders[Excel.XlBordersIndex.xlEdgeLeft].Color = Color.Blue.ToArgb();
rng.Borders[Excel.XlBordersIndex.xlEdgeRight].Color = Color.Blue.ToArgb();
rng.Borders[Excel.XlBordersIndex.xlEdgeTop].Color = Color.Blue.ToArgb();
rng.Borders[Excel.XlBordersIndex.xlInsideHorizontal].Color = Color.Blue.ToArgb();
rng.Borders[Excel.XlBordersIndex.xlInsideVertical].Color = Color.Blue.ToArgb();
xlWs.get_Range((Excel.Range)xlWs.Cells[4, 1], (Excel.Range)xlWs.Cells[xlWs.UsedRange.Rows.Count, clsLists.getEMCTSReleaseDetailsExportParamList().Count]).EntireColumn.AutoFit();
}
xlApp.Visible = true;
return Json(new { Error = "Please save file" });
}
catch (Exception e)
{
xlApp.Visible = true;
return Json(new { Error = "Failed to generate the report" });
}
}
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
13
)
Next Recommended Forum
how to create a chat application in c#
Exception Handling problem