How to generate the data from gridview to excel

Mahesh Babu

8y1.2k.NET

How to generate the data from grid view to excel

My Requirement is

i created my datatable

i need to generate the data randomly when i click the button to the excel

below u can find the code

private DataTable GetDetails(int id)

{

_dt = new DataTable();

_da = new SqlDataAdapter("sp_GetDetails", _con);

_da.SelectCommand.Parameters.AddWithValue("@id", id);

_da.SelectCommand.CommandType = CommandType.StoredProcedure;

_dt.Clear();

_da.Fill(_dt);

return _dt;

}

please help me this

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Leon D8y ago
Accepted answer
Hi,

An easy way is to use free spire.xls library. You can get free spire.xls dll from NuGet:
https://www.nuget.org/packages/FreeSpire.XLS/

And then use code like below to export data from data table to excel:
Workbook workbook = new Workbook();

workbook.Version = ExcelVersion.Version2013;

Worksheet sheet = workbook.Worksheets[0];

sheet.InsertDataTable(datatable, true, 1, 1);

workbook.SaveToFile("ExportDataToExcel.xlsx",ExcelVersion.Version2013);
0
Chandan Prasad8y ago
please look into the below link.

https://stackoverflow.com/questions/15832339/gridview-data-export-to-excel-in-asp-net
0
Aakash Maurya8y ago
Here is the great article for you to export grid to excel

https://www.c-sharpcorner.com/UploadFile/0c1bb2/export-gridview-to-excel/

I haven't tried Grid to Excel, but I have worked with Grid to CSV.
+1