how ro export data

Gokul

10y975Visual Basic .NET

how to database data will be save the the excel file

7 Replies

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

Rajeesh Menoth10y ago
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.
0
Gokul10y ago
hi lisa, which Namespace i have to use
0
Lisa White10y ago
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.
0
Imtiyaz Ansari10y ago
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 < dataGridView1.Rows.Count - 1)
{
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 < dt.Columns.Count; i++)
{
wr.Write(dt.Columns[i].ToString().ToUpper() + "\t");
}
wr.WriteLine();
//write rows to excel file
for (int i = 0; i < (dt.Rows.Count); i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Rows[i][j] != null)
{
wr.Write(Convert.ToString(dt.Rows[i][j]) + "\t");
}
else
{
wr.Write("\t");
}
}
wr.WriteLine();
}
wr.Close();
}
+1
Rajeesh Menoth10y ago
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
0
Gokul10y ago
hi.... using c# windows application
0
Rajeesh Menoth10y ago
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
0