Unable to create the excel file after publishing the c# code

DataSet dtvendor = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("FoodGroupFinalExcelReport", con);
da.Fill(dtvendor);
Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
excel.Application.Workbooks.Add(true);
System.Data.DataTable table = dtvendor.Tables[0];
int ColumnIndex = 0;
Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)excel.ActiveSheet;
DataTable dtRepGrpInfo = new DataTable();
foreach (System.Data.DataColumn col in table.Columns)
{
ColumnIndex++;
excel.Cells[1, ColumnIndex] = col.ColumnName;
}
int rowIndex = 0;
foreach (DataRow row in table.Rows)
{
rowIndex++;
ColumnIndex = 0;
foreach (DataColumn col in table.Columns)
{
ColumnIndex++;
excel.Cells[rowIndex + 1, ColumnIndex] = row[col.ColumnName];
}
}
string file = "FoodGroup-" + id + ".xlsx";
var fileSavePath = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Reports"), file);
excel.Application.ActiveWorkbook.SaveCopyAs(fileSavePath);
Process procStart = new Process();
procStart.StartInfo.FileName = fileSavePath;
procStart.Start();

5 Replies

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

Revathi Parvathi9y ago
1. DataSet dtvendor = new DataSet();
2. SqlDataAdapter da = new SqlDataAdapter("FoodGroupFinalExcelReport", con);
3. da.Fill(dtvendor);
4. Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
5. excel.Application.Workbooks.Add(true);
6. System.Data.DataTable table = dtvendor.Tables[0];
7. int ColumnIndex = 0;
8. Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)excel.ActiveSheet;
9. DataTable dtRepGrpInfo = new DataTable();
10. foreach (System.Data.DataColumn col in table.Columns)
11. {
12. ColumnIndex++;
13. excel.Cells[1, ColumnIndex] = col.ColumnName;
14. }
15. int rowIndex = 0;
16. foreach (DataRow row in table.Rows)
17. {
18. rowIndex++;
19. ColumnIndex = 0;
20. foreach (DataColumn col in table.Columns)
21. {
22. ColumnIndex++;
23. excel.Cells[rowIndex + 1, ColumnIndex] = row[col.ColumnName];
24. }
25. }
26. string file = "FoodGroup-" + id + ".xlsx";
27. var fileSavePath = Path.Combine(System.Web.HttpContext.Current.Server.MapPath("~/Reports"), file);
28. excel.Application.ActiveWorkbook.SaveCopyAs(fileSavePath);
29. Process procStart = new Process();
30. procStart.StartInfo.FileName = fileSavePath;
31. procStart.Start();
This is my code which is creating an excel file when I am running through visual studio 2013.But My application wants to host in IIS Server, After hosting this code in IIS it is not creating the excel file and it shows page not redirect error.

FYI, I don't know how to do debug the code through IIS after publishing it in IIS server.