Export to Excel is working in local but in server after deploying

[binod06]

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 is not working. i mean not exporting to excel. Even it's not generating any error also. can any one help me please.

thanks to you all in advance.

Binod

[cridley]

Is this a website?
If so, that code will be trying to open excel on the server as that is where it is running. You cannot open excel directly from the web browser on the local machine, for that you would need an ActiveX object.