how ro export data

Question

how to database data will be save the the excel file

Imtiyaz Ansari · Answer

Hello Gokul if you want Export Data in Excel Format then best way firstly Bind DataGirdView Then Export Excel... //====Button Click Event For Export Excel====== //====Button Click Event For Export Excel====== private void button1_Click(object sender, EventArgs e) { if (dataGridView1.Rows.Count > 0) { try { // Bind Grid Data to Datatable DataTable dt = new DataTable(); foreach (DataGridViewColumn col in dataGridView1.Columns) { dt.Columns.Add(col.HeaderText, col.ValueType); } int count = 0; foreach (DataGridViewRow row in dataGridView1.Rows) { if (count { dt.Rows.Add(); foreach (DataGridViewCell cell in row.Cells) { dt.Rows[dt.Rows.Count - 1][cell.ColumnIndex] = cell.Value.ToString(); } } count++; } // Bind table data to Stream Writer to export data to respective folder StreamWriter wr = new StreamWriter(@ "E:\Book1.xls" ); // Write Columns to excel file for ( int i = 0; i { wr.Write(dt.Columns[i].ToString().ToUpper() + "	" ); } wr.WriteLine(); //write rows to excel file for ( int i = 0; i { for ( int j = 0; j { if (dt.Rows[i][j] != null) { wr.Write(Convert.ToString(dt.Rows[i][j]) + "	" ); } else { wr.Write( "	" ); } } wr.WriteLine(); } wr.Close(); }

Rajeesh Menoth · Answer

Hi Gokul, Regarding the lisa solution.You can use Spire.XLS name space. If you are using e-iceblue Spire.XLS Then you can easily convert with in a few steps.But some limitations are there.They will provide 30 days trail if you want to more than 30 days you want to pay them.More details just contact e-iceblue support team.

Gokul · Answer

hi lisa, which Namespace i have to use

Lisa White · Answer

Hi Gokul, You can refer to following article to export data from database to excel, check: http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data-Export-/Import-Export-Datatable-to-Excel-from-Database.html Hope this would be helpful.

Rajeesh Menoth · Answer

Hi, Check this following reference : http://csharp.net-informations.com/excel/csharp-excel-export.htm http://www.c-sharpcorner.com/blogs/export-sql-table-data-into-excel-using-c-sharpnet-application1

Gokul · Answer

hi.... using c# windows application

Rajeesh Menoth · Answer

Hi, Check the following reference : http://www.c-sharpcorner.com/UploadFile/cd7c2e/export-sql-data-to-excel-using-Asp-Net/ http://www.encodedna.com/2013/01/asp.net-export-to-excel.htm http://www.aspsnippets.com/Articles/Read-and-Import-Excel-Sheet-into-SQL-Server-Database-in-ASP.Net.aspx

how ro export data

Answers (7)