How to download SQL database table data into excel sheet using C#?

Quote:

Using this code i am not able to get first record in excel sheet

You are not getting the first record because your loop starts at 1 as shown in the following:

for (int j = 1; j < dt.Columns.Count + 1; j++)

and then you have the following code inside it:

ExcelApp.Cells[i, j] = dcc[j - 1].ToString();

Keep in mind that index of Cells starts at 0 so I think that causes the issue why you don't see the first record. Try something like this instead:

if (i == 1)
                {
                    ExcelApp.Cells[i-1, j-1] = dcc[j - 1].ToString();
                }
                else { ExcelApp.Cells[i-1, j-1] = dt.Rows[i - 1][j - 1].ToString();
                }

Or you could change your loop to start at 0 instead of 1 so your code would now look something like this:

for (int i = 0; i < dt.Rows.Count; i++)
        {
            for (int j = 0; j < dt.Columns.Count; j++)
            {
                if (i == 0)
                {
                    ExcelApp.Cells[i, j] = dcc[j].ToString();
                }
                else { ExcelApp.Cells[i, j] = dt.Rows[i][j].ToString();
                }

            }
        }

If you are still having an unexpected results, I would suggest you to debug your code, set a break point to your for-loop code and then step into it to figure out what the data is being transported.

You've tagged this question as ASP.NET, which means your code has several problems.

Firstly, you cannot use Office Interop from ASP.NET:

Considerations for server-side Automation of Office[^]

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

There are various ways to create Excel spreadsheets on the server without using Office interop. For example:

• EPPlus[^];
• ClosedXML[^];
• The OpenXML SDK[^];

Secondly, your code is saving the Excel file on the server. It is NOT downloading the file to the client. It might appear to work when you test it in Visual Studio, but that's only because the client and server are the same computer in that specific case. Once you deploy your code to a real server, you'll end up with lots of files stored on the server, and lots of confused users who can't find the file that your code says has just been downloaded.

To send the file to the client, you need to write it to the response, along with the correct content-type header. The user will then be able to choose what to do with the file.

NB: You cannot send any other content in the response.

NB: You cannot control where, or even if, the user saves the file.

Better use:

for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
................

}
}

or look here: Mikes Knowledge Base - Export to Excel[^]