C#NET2008 Excel MergeCells Problem

See more:

C#3.5

Hello Good Friends,

Please help me. I need your help.

Regarding excel spreadsheet at row 1 and Column.cells 1 to Column.cells 5, I am trying to do merge cells in order to insert customer company name on it, but the coding is not working as I didn't done it before. Please help me.

Here are the coding relating to it.

Microsoft.Office.Interop.Excel.Application  objExcel;
Microsoft.Office.Interop.Excel.Workbook objWrkbook;
Microsoft.Office.Interop.Excel.Worksheet objWrkSheet;
Object objRange =  System.Office.Interop.Excel
ObjExcel.Visible = true;	
intRow = 1;
objWrkSheet =(objWrkSheet.Cells[intRow, 1] , objWrkSheet.Cells[intRow,5]).MergeCells = true;
//display Customer Company name on row 1 Merged cells.
obkWrksheet.Cells(intRow,1) = this.txtCompanyName.text;