Display data in excel file from data table in desired location

See more:

C#

.NET

WinForms

Hi
By using below code, it always inserts data into starting cell. I can generate excel file but I need to insert the data into different cells starting from H5 or I9 cell. Can anyone please look into this.

Excel.Application excelApp = new Excel.Application();
excelApp.Workbooks.Add();

// single worksheet
Excel._Worksheet workSheet = excelApp.ActiveSheet;

// column headings
for (int i = 0; i < dt.Columns.Count; i++)
{
workSheet.Cells[1, (i + 1)] = dt.Columns[i].ColumnName;
}

// rows
for (int i = 0; i < dt.Rows.Count; i++)
{
// to do: format datetime values before printing
for (int j = 0; j < dt.Columns.Count; j++)
{
workSheet.Cells[(i + 2), (j + 1)] = dt.Rows[i][j];
}
}
excelApp.Visible = true;