User-1997017258 posted
Hi all
i am new in this forum.and really happy to join this.
i am doing export to excel operation using below code.
public
void ExcelExport(System.Data.DataTable tblExportData,
string TempFilePath,string userInfo,bool
headerStatus)
{
try
{
Microsoft.Office.Interop.Excel.
Application excelApp =
new Microsoft.Office.Interop.Excel.Application();
excelApp.Workbooks.Open(TempFilePath, Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing,
Type.Missing);
//Writing Header in Excel
if (headerStatus ==
true)
{
for (int i = 0; i < tblExportData.Columns.Count; i++)
{
excelApp.Cells[7, i + 1] = tblExportData.Columns[i].ColumnName;
}
}
//Writing Data in Excel
for (int i = 1; i <= tblExportData.Rows.Count;
i++)
{
for (int j = 0; j < tblExportData.Columns.Count; j++)
{
string colName = tblExportData.Columns[j].ColumnName;
excelApp.Cells[i + 7, j+1] = tblExportData.Rows[i-1][colName];
}
}
//Create a worksheet object
Microsoft.Office.Interop.Excel.Sheets sheets = excelApp.Worksheets;
//from the collection of worksheet select one worksheet
Microsoft.Office.Interop.Excel.Worksheet mySheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
//select the cell in the worksheet
Microsoft.Office.Interop.Excel.
Range myCell1 = (Microsoft.Office.Interop.Excel.Range)mySheet.get_Range("A6",
"A6");
myCell1.Value2 = userInfo;
myCell1.Font.Color = System.Drawing.Color.Black.ToArgb();
excelApp.Visible = true;
}
catch (Exception ex)
{
}
}
it's working fine. but when i deployed this on relience server then it stops to work. i mean exporting to excel not working. Even it's not generating any error also. can any one help me please.
thanks to you all in advance.
Binod
