Exporting Contents From Data Grid To Excel?

I'm trying to export the content of a data grid to an Excel file. But here is my problem:

1. If I use a Data Grid which was set to allow Adding and Editing of columns ( this appeared the first time I add the control to the form) , the resulting excel file will show all the content of the data grid, except for the Headers ( Column names) .

2. If I use a Data grid which was set to disabled adding and editing of columns, the resulting excel file is lacking the bottom-most row of the data grid content. The Headers are also not included.

I cannot choose Option 1, since the data grid must not be editable by the user. I cannot choose option 2 since the last row is being omitted. Another thing is that the Column Names ( the data are coming from a MS Access File) are not added into the Excel File for both Option 1 and 2.

Here is the code I'm using. I found it from the net and tried changing the values of i and j but still I can't get the result I wanted.

For i = 0 To dgreport3.RowCount - 2
For j = 0 To dgreport3.ColumnCount - 1
xlWorkSheet.Cells(i + 1, j + 1) = _
dgreport3(j, i).Value.ToString()
Next
Next