How do I add data to a "specific" cell in an excel sheet with c#

See more:

C#

MS-Excel

Hi everyone!

I'm a little bit stuck here. I'm building somewhat of a data base with excel. Now I want the user to be able to add new data to it whenever necessary. For that I have created a program so far that gets specific data from excel files and writes those to a datable. This works just fine. Now I want to add the data of the datatable to my excel data base. But I always want the new data to be placed into the nexr free row. My code is not working correctly though. It over writes the headers of the excel file. Maybe I missunderstand the get_Range method, but right now I'm clueless.
This is the code I have so far:

private void datatableToMasterfile(DataTable drToEx)
{
    string masterfileName = @"C:\Users\q371298\Desktop\Datenbank\Datenbank_Reifen_080415.xls";

    // open Masterfile
    Excel.Application xl = new Excel.Application();
    Excel.Workbook wb = xl.Workbooks.Open(masterfileName);
    Excel.Worksheet wsDatenBank = wb.Sheets.get_Item(1);

    //Check for last filled row
    Excel.Range dbRange = (Excel.Range)wsDatenBank.Cells[wsDatenBank.Rows.Count, 1];
    int lastRow = (int)dbRange.get_End(Excel.XlDirection.xlUp).Row+3; 
    int newRow = lastRow + 1; 
    
    //Create Array to hold the data of DataTable
    object[,] arr = new object[drToEx.Rows.Count, drToEx.Columns.Count];

    //Fill DataTable in Array
    for (int r = 0; r < drToEx.Rows.Count; r++)
    {
        DataRow dr1 = drToEx.Rows[r];
        for (int c =0; c < drToEx.Columns.Count; c++)
        {
            arr[r, c] = dr1[c];
        }
    }

    //Set Excel Range to paste the data
    Excel.Range startCell = (Excel.Range)wsDatenBank.Cells[newRow, 1];
    Excel.Range endCell = (Excel.Range)wsDatenBank.Cells[1 + drToEx.Rows.Count - 1, drToEx.Columns.Count];
    Excel.Range range = wsDatenBank.get_Range(startCell, endCell);
   
    //Fill array in Excel
    range.Value = arr;
    
    xl.Visible = true;    
}

I would really appreciate the help, as I am still fairly new to this.

Thanx a lot!

Susie