C # Implementation inserts rows and columns into Excel, and sets the cell Merge center effect

Insert Blank line:

Microsoft.Office.Interop.Excel.Workbook Xlsworkbook;

Microsoft.Office.Interop.Excel.Worksheet xlssheet = xlsworkbook.worksheets[1];

Microsoft.Office.Interop.Excel.Range xlsrow= (Microsoft.Office.Interop.Excel.Range) xlssheet.rows[3,misvalue];

Xlsrow.insert (Microsoft.office.interop.excel.xlshiftdown,misvalue);

Insert an empty column:

Excel.Range xlscolumns = (excel.range) ws. Columns[index, Type.Missing];

Xlscolumns.insert (Excel.XlInsertShiftDirection.xlShiftToRight, Type.Missing);

String columnletter = Getletter (index-1);
Ws. cells[2, index] = TxtBoxExpenseType.Text.Trim ();
Excel.Range Newexpensetyperange = Ws.get_range (string. Format ("{0}{1}", Columnletter, 2), String. Format ("{0}{1}", Columnletter, 3));
Newexpensetyperange.mergecells = true;
Newexpensetyperange.verticalalignment = Excel.XlVAlign.xlVAlignCenter;
Newexpensetyperange.horizontalalignment = Excel.XlVAlign.xlVAlignCenter;

public static string getletter (int index)
        {
             if (Index < 0) {throw new Exception ("Invalid parameter "); }

List chars = new list ();
Do
{
if (chars. Count > 0) index--;
Chars. Insert (0, ((char) (index% + (int) ' A ')). ToString ());
index = (int) ((index-index% 26)/26);
} while (index > 0);

Return String.Join (String. Empty, chars. ToArray ());
}

C # Implementation inserts rows and columns into Excel, and sets the cell Merge center effect