how to reduce Excel file downloading execution time in mvc

I have generated code for creating excel file to generating each cell for the row in MVC.

I have more than 20000 records that time 15 min required for generating one excel file.so i want minimum time for downloading excel file.their is column generated is dynamic.

public ActionResult ExportToExcel(int SurveyId)
{
var _checlAuth = this.CheckAuthentication();
if (_checlAuth != null)
{
return _checlAuth;
}
//string fileName = System.Web.Configuration.WebConfigurationManager.AppSettings["ExcelPath"].ToString() + "\\SurveyReport.xlsx";
string fileName = System.Web.Configuration.WebConfigurationManager.AppSettings["ExcelPath"].ToString() + "\\SurveyReport_" + DateTime.Now.Day + DateTime.Now.Hour + DateTime.Now.Minute + DateTime.Now.Second + DateTime.Now.Millisecond + "_" + SurveyId + ".xlsx";
//"D:\\SurveyReport.xlsx";
// Create a spreadsheet document by supplying the file name.
SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.
Create(fileName, SpreadsheetDocumentType.Workbook);
// Add a WorkbookPart to the document.
WorkbookPart workbookpart = spreadsheetDocument.AddWorkbookPart();
workbookpart.Workbook = new Workbook();
// Add a WorksheetPart to the WorkbookPart.
WorksheetPart worksheetPart = workbookpart.AddNewPart();
worksheetPart.Worksheet = new Worksheet(new SheetData());
// Add Sheets to the Workbook.
Sheets sheetsStudentDetails = spreadsheetDocument.WorkbookPart.Workbook.
AppendChild(new Sheets());
// Append a new worksheet and associate it with the workbook.
Sheet sheetStudentDetail = new Sheet()
{
Id = spreadsheetDocument.WorkbookPart.
GetIdOfPart(worksheetPart),
SheetId = 1,
Name = "Survey Details",
};
SheetData sheetData = worksheetPart.Worksheet.GetFirstChild();
// Add a row to the cell table.
Row row = new Row();
sheetsStudentDetails.Append(sheetStudentDetail);
var Question = new BussinessLogic.Admin.UserSurvey(new UserSurveyRepository(new CRMContext())).GetAllUserSurvey().Where(m => m.SurveyId == SurveyId);
//excelWorksheet.Name = "Admission Data";
int i = 1;
int j = 1;
int kk = 2;
var countResponse= new BussinessLogic.Answer.Answer(new AnswerRepository(new CRMContext())).GetAllAnswer().Where(a => a.SurveyId == SurveyId).Select(a => a.EachSurveyUniqueNo).Distinct().ToList();
var AllQAnswer = new BussinessLogic.Answer.Answer(new AnswerRepository(new CRMContext())).GetAllAnswer();
var AllQueAnswerOption = new BussinessLogic.Admin.QuestionAnswer(new QuestionAnswerRepository(new CRMContext())).GetAllQuestionAnswer();
row.Append(ConstructCell("Conducted Survey Id", CellValues.String));
row.Append(ConstructCell("Survey Name", CellValues.String));
row.Append(ConstructCell("Survey Id", CellValues.String));
// row.Append(ConstructCell("Submitted Id", CellValues.String));
row.Append(ConstructCell("Date & Time", CellValues.String));
row.Append(ConstructCell("Submitted By", CellValues.String));
foreach (var q in Question)
{
var QuestionRow = new BussinessLogic.Admin.QuestionAnswer(new QuestionAnswerRepository(new CRMContext())).GetAllQuestionAnswer().Where(k => k.QuestionId == q.Id && k.ColumnOption == null);
Row rans = new Row();
if (q.QuestionTypeId == 1)
{
row.Append(ConstructCell(q.QuestionText, CellValues.String));
}
if (q.QuestionTypeId == 2)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id).ToList();
foreach (var anss in optanser)
{
row.Append(ConstructCell(q.QuestionText + ": " + anss.AnswerOption, CellValues.String));
}
}
if (q.QuestionTypeId == 3)
{
row.Append(ConstructCell(q.QuestionText, CellValues.String));
}
if (q.QuestionTypeId == 5)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id).ToList();
foreach (var anss in optanser)
{
row.Append(ConstructCell(q.QuestionText + ": " + anss.AnswerOption, CellValues.String));
}
}
if (q.QuestionTypeId == 6)
{
row.Append(ConstructCell(q.QuestionText, CellValues.String));
}
if (q.QuestionTypeId == 7)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id).ToList();
foreach (var anss in optanser)
{
row.Append(ConstructCell(q.QuestionText + ": " + anss.AnswerOption, CellValues.String));
}
}
if (q.QuestionTypeId == 8)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id).ToList();
foreach (var anss in optanser)
{
row.Append(ConstructCell(q.QuestionText + ": " + anss.AnswerOption, CellValues.String));
}
}
if (q.QuestionTypeId == 9)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id).ToList();
foreach (var anss in optanser)
{
row.Append(ConstructCell(q.QuestionText + ": " + anss.AnswerOption, CellValues.String));
}
}
if (q.QuestionTypeId == 10)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.ColumnOption==null).ToList();
foreach (var anss in optanser)
{
foreach(var colum in AllQueAnswerOption.Where(a=>a.QuestionId==q.Id && a.AnswerOption==null).ToList())
{
row.Append(ConstructCell(q.QuestionText + ":- " + anss.AnswerOption + " : " + colum.ColumnOption, CellValues.String));
}
}
}
if (q.QuestionTypeId == 11)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.ColumnOption == null && a.DataOptions==null).ToList();
foreach (var anss in optanser)
{
foreach (var colum in AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.AnswerOption == null && a.DataOptions==null).ToList())
{
row.Append(ConstructCell(q.QuestionText + ":- " + anss.AnswerOption + " : " + colum.ColumnOption, CellValues.String));
}
}
}
if (q.QuestionTypeId == 12)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.ColumnOption == null && a.DataOptions==null).ToList();
foreach (var anss in optanser)
{
foreach (var colum in AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.AnswerOption == null && a.DataOptions==null).ToList())
{
row.Append(ConstructCell(q.QuestionText + ":- " + anss.AnswerOption + " : " + colum.ColumnOption, CellValues.String));
}
}
}
if (q.QuestionTypeId == 13)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.ColumnOption == null).ToList();
foreach (var anss in optanser)
{
foreach (var colum in AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.AnswerOption == null).ToList())
{
row.Append(ConstructCell(q.QuestionText + ":- " + anss.AnswerOption + " : " + colum.ColumnOption, CellValues.String));
}
}
}
if (q.QuestionTypeId == 14)
{
var optanser = AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.ColumnOption == null).ToList();
foreach (var anss in optanser)
{
foreach (var colum in AllQueAnswerOption.Where(a => a.QuestionId == q.Id && a.AnswerOption == null).ToList())
{
row.Append(ConstructCell(q.QuestionText + ":- " + anss.AnswerOption + " : " + colum.ColumnOption, CellValues.String));
}
}
}
if (q.QuestionTypeId == 15)
{
row.Append(ConstructCell(q.QuestionText, CellValues.String));
}
}
sheetData.AppendChild(row);
int count = 1;
var alluser = new BussinessLogic.User.User(new Repository.UserRepository(new CRMContext())).GetAllUsers();
var allsurvey = new BussinessLogic.Admin.Survey(new SurveyRepository(new CRMContext())).GetAllSurvey().Where(a=>a.Id==SurveyId).FirstOrDefault();
foreach (var co in countResponse)
{
Row rans1 = new Row();
rans1.Append(ConstructCell(co.ToString(), CellValues.String));
if (allsurvey.SurveyName!=null)
{
rans1.Append(ConstructCell(allsurvey.SurveyName, CellValues.String));
rans1.Append(ConstructCell(allsurvey.Id.ToString(), CellValues.String));
}
else
{
rans1.Append(ConstructCell("None", CellValues.String));
}
var surveyInfo = AllQAnswer.Where(a => a.EachSurveyUniqueNo == co).FirstOrDefault();
if(surveyInfo!=null)
{
rans1.Append(ConstructCell(surveyInfo.CreatedDate.ToString(), CellValues.String));
}
else
{
rans1.Append(ConstructCell("None", CellValues.String));
}
var userNm = alluser.Where(a => a.id == surveyInfo.UserId).FirstOrDefault();
if(userNm!=null)
{
rans1.Append(ConstructCell(userNm.name + " " + userNm.LastName, CellValues.String));
}
else
{
rans1.Append(ConstructCell("None", CellValues.String));
}
foreach (var qq in Question)
{
var QuestionRow1 = new BussinessLogic.Admin.QuestionAnswer(new QuestionAnswerRepository(new CRMContext())).GetAllQuestionAnswer().Where(k => k.QuestionId == qq.Id && k.ColumnOption == null);
if (qq.QuestionTypeId == 1)
{
var openeded = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (openeded != null)
{
var ansopt = AllQueAnswerOption.Where(a => a.Id == openeded.SelectedAnswerOptionId && a.QuestionId == openeded.QuestionId).FirstOrDefault();
if(ansopt.AnswerOption.Equals("Other (Please specify)"))
{
rans1.Append(ConstructCell(openeded.isOtherField, CellValues.String));
}
else
{
rans1.Append(ConstructCell(ansopt.AnswerOption, CellValues.String));
}
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
if(qq.QuestionTypeId==2)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m=>m.QuestionId==qq.Id).ToList())
{
var Ques = AllQAnswer.Where(a => a.QuestionId == da.QuestionId && a.EachSurveyUniqueNo == co && a.SelectedAnswerOptionId == da.Id).FirstOrDefault();
if(Ques!=null)
{
var ansopt = AllQueAnswerOption.Where(a => a.Id == Ques.SelectedAnswerOptionId && a.QuestionId == Ques.QuestionId).FirstOrDefault();
if(ansopt.AnswerOption.Equals("Other (Please specify)"))
{
rans1.Append(ConstructCell(Ques.isOtherField, CellValues.String));
}
else
{
rans1.Append(ConstructCell(da.AnswerOption, CellValues.String));
}
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
if (qq.QuestionTypeId == 3)
{
var openeded = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (openeded != null)
{
if (openeded.Description == null)
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
else
{
rans1.Append(ConstructCell(openeded.Description, CellValues.String));
}
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
if (qq.QuestionTypeId == 5)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
rans1.Append(ConstructCell("0", CellValues.String));
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
var Ques = AllQAnswer.Where(a => a.QuestionId == da.QuestionId && a.EachSurveyUniqueNo == co && a.SelectedAnswerOptionId == da.Id).FirstOrDefault();
if (Ques !=null)
{
rans1.Append(ConstructCell(Ques.Value.ToString(), CellValues.String));
}
else
{
rans1.Append(ConstructCell("0", CellValues.String));
}
}
}
}
if (qq.QuestionTypeId == 6)
{
var openeded = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (openeded != null)
{
if (openeded.Description == null)
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
else
{
rans1.Append(ConstructCell(openeded.Description, CellValues.String));
}
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
if (qq.QuestionTypeId == 7)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
var Ques = AllQAnswer.Where(a => a.QuestionId == da.QuestionId && a.EachSurveyUniqueNo == co && a.SelectedAnswerOptionId == da.Id).FirstOrDefault();
if (Ques != null)
{
rans1.Append(ConstructCell(Ques.Value.ToString(), CellValues.String));
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
if (qq.QuestionTypeId == 8)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
var Ques = AllQAnswer.Where(a => a.QuestionId == da.QuestionId && a.EachSurveyUniqueNo == co && a.SelectedAnswerOptionId == da.Id).FirstOrDefault();
if (Ques != null)
{
rans1.Append(ConstructCell(Ques.Value.ToString(), CellValues.String));
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
if (qq.QuestionTypeId == 9)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
{
var Ques = AllQAnswer.Where(a => a.QuestionId == da.QuestionId && a.EachSurveyUniqueNo == co && a.SelectedAnswerOptionId == da.Id).FirstOrDefault();
if (Ques != null)
{
rans1.Append(ConstructCell(Ques.Value.ToString(), CellValues.String));
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
if (qq.QuestionTypeId == 10)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if(ans==null)
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
if (ans.Count() == 0)
{
//foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
//{
// rans1.Append(ConstructCell("NA", CellValues.String));
//}
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption==null).ToList())
{
foreach(var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null).ToList())
{
var fin = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.RowId ==da.Id && a.ColumId == col.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if(fin!=null)
{
if(fin.Description==null)
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
else
{
rans1.Append(ConstructCell(fin.Description, CellValues.String));
}
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
}
if (qq.QuestionTypeId == 11)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
//foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
//{
// rans1.Append(ConstructCell("NA", CellValues.String));
//}
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null && m.DataOptions == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null && m.DataOptions == null).ToList())
{
if (col != null)
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null && m.DataOptions==null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null && m.DataOptions==null).ToList())
{
var fin = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.RowId == da.Id && a.ColumId == col.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (fin != null)
{
if(fin.Description==null)
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
else
{
rans1.Append(ConstructCell(fin.Description, CellValues.String));
}
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
}
if (qq.QuestionTypeId == 12)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
//foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
//{
// rans1.Append(ConstructCell("NA", CellValues.String));
//}
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null && m.DataOptions == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null && m.DataOptions == null).ToList())
{
// if (col != null)
// {
rans1.Append(ConstructCell("NA", CellValues.String));
// }
}
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null && m.DataOptions==null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null && m.DataOptions==null).ToList())
{
var fin = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.RowId == da.Id && a.ColumId == col.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (fin != null)
{
var dataopt = AllQueAnswerOption.Where(a => a.Id == fin.SelectedDataId && a.QuestionId == qq.Id).FirstOrDefault();
if(dataopt==null)
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
else
{
rans1.Append(ConstructCell(dataopt.DataOptions, CellValues.String));
}
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
}
if (qq.QuestionTypeId == 13)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
//foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
//{
// rans1.Append(ConstructCell("NA", CellValues.String));
//}
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null).ToList())
{
var fin = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.RowId == da.Id && a.ColumId == col.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (fin != null)
{
rans1.Append(ConstructCell(col.ColumnOption, CellValues.String));
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
}
if (qq.QuestionTypeId == 14)
{
var ans = AllQAnswer.Where(m => m.QuestionId == qq.Id && m.EachSurveyUniqueNo == co).ToList();
if (ans.Count() == 0)
{
//foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id).ToList())
//{
// rans1.Append(ConstructCell("NA", CellValues.String));
//}
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null).ToList())
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
else
{
foreach (var da in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.ColumnOption == null).ToList())
{
foreach (var col in AllQueAnswerOption.Where(m => m.QuestionId == qq.Id && m.AnswerOption == null).ToList())
{
var fin = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.RowId == da.Id && a.ColumId == col.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (fin != null)
{
rans1.Append(ConstructCell(col.ColumnOption, CellValues.String));
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
}
}
if (qq.QuestionTypeId==15)
{
var openeded = AllQAnswer.Where(a => a.QuestionId == qq.Id && a.EachSurveyUniqueNo == co).FirstOrDefault();
if (openeded!=null)
{
rans1.Append(ConstructCell(openeded.Value.ToString(), CellValues.String));
}
else
{
rans1.Append(ConstructCell("NA", CellValues.String));
}
}
}
count++;
sheetData.AppendChild(rans1);
}
worksheetPart.Worksheet.Save();
//sheetData.AppendChild(row);
string contentType = "application/excel";
spreadsheetDocument.Close();
return File(fileName, contentType, "surveyExcel_Report"+System.DateTime.Now+".xlsx");
//return View();
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kalyani Shevale7y ago
I have Used Joins in LINQ but same execution time required......any another option
Piyush Pansuriya7y ago
Hi,
You are using foreach and linq nestedly, so it will take time necessarily.

Try to optimize with using join in linq.
for example:

before your foreach use join

var abc = from a in Question
join b in AllQueAnswerOption on a.Id equals b.QuestionId

foreach (var q in abc)
{

}

May be helps you.
Kalyani Shevale7y ago
@piyush
u have suggested switch case I have to try switch case through but that time minimum 200 row that time 15 minute time required so how to reduce this time?????
Piyush Pansuriya7y ago
Hi Kalyani,

As looking your code, I think you have to optimize somethings in your code.
Like when you write the conditions if (q.QuestionTypeId == 6) , if (q.QuestionTypeId == 7), if (q.QuestionTypeId == 8) etc.. It is better to use switch case instead of if.

Other than that, code wise it looks good.!!