Microsoft.Office.Interop.Excel.Application objExcel = new Microsoft.Office.Interop.Excel.Application();
Microsoft.Office.Interop.Excel.Workbook objworkbook;
Microsoft.Office.Interop.Excel.Worksheet objworksheet;
try
{
objExcel.DisplayAlerts = false;
objExcel.Visible = false;
Range objRange = null;
int row = 1, col = 1;
objworkbook = objExcel.Workbooks.Open(newFilePath, true, false,
Type.Missing, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, true, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);
objworksheet = (Microsoft.Office.Interop.Excel.Worksheet)objworkbook.Sheets.get_Item("Sheet2");
int j = col;
for (int i = 0; i < Mastrerfieldname.Length; i++)
{
objRange = (Range)objworksheet.Cells[row, j];
objRange.Value2 = Mastrerfieldname[i].ToString();
objRange.Font.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.White);
objRange.Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.DarkBlue);
j++;
}
row++;
objworksheet.Name = "MasterDetails";
object objOpt = Missing.Value;
objworkbook.Save();
objworkbook.Close(Microsoft.Office.Interop.Excel.XlSaveAction.xlSaveChanges, Type.Missing, Type.Missing);
objExcel.Quit();
}
catch (Exception ex)
{
throw ex;
}
finally
{
objExcel = null;
objworkbook = null;
objworksheet = null;
ReleaseComObject(objExcel);
ReleaseComObject(objworkbook);
ReleaseComObject(objworksheet);
}
//Release COM objects from memory
public void ReleaseComObject(object reference)
{
try
{
while (System.Runtime.InteropServices.Marshal.ReleaseComObject(reference) <= 0)
{
}
}
catch
{
}
}
}