Answer / mohanraja

The belo code is Export the Listview Data's into Excel...
It exports two columns, Cell Number and Name...


Imports System.IO

Try

Dim st As String() = New
String(lst_phone.Columns.Count - 1) {}
Dim di As New DirectoryInfo("c:\")
If di.Exists = False Then
di.Create()
End If
Dim sw As New
StreamWriter(sfd.FileName, False)
sw.AutoFlush = True
For col As Integer = 0 To
lst_phone.Columns.Count - 1
sw.Write("" & Chr(9) & "" +
lst_phone.Columns(col).Text.ToString())
Next

Dim rowIndex As Integer = 1
Dim row As Integer = 0
Dim st1 As String = ""
For row = 0 To lst_phone.Items.Count - 1
If rowIndex <=
lst_phone.Items.Count Then
rowIndex += 1
End If
st1 = "" & Chr(10) & ""
For col As Integer = 0 To
lst_phone.Columns.Count - 1
'st1 = st1 + "" & Chr(9) &
"" + "'" + lst_phone.Items(row).SubItems(col).Text.ToString()
st1 = st1 + "" & Chr(9) & ""
+ lst_phone.Items(row).SubItems(col).Text.ToString()
Next
sw.WriteLine(st1)
Next
sw.Close()

Dim fil As New FileInfo(sfd.FileName)

If fil.Exists = True Then

MsgBox("Your Data Exported into
Excel Sheet Successfully......!", MsgBoxStyle.Information,
"Exported")
End If
Catch ex As Exception
End Try

Answer / santoshsutar1983

protected void Button3_Click(object sender, EventArgs e)

{

DataTable dt = GetData();

string attachment = "attachment;
filename=Employee.xls";

Response.ClearContent();

Response.AddHeader("content-disposition",
attachment);

Response.ContentType = "application/vnd.ms-excel";

string tab = "";

foreach (DataColumn dc in dt.Columns)

{

Response.Write(tab + dc.ColumnName);

tab = "\t";

}

Response.Write("\n");



int i;

foreach (DataRow dr in dt.Rows)

{

tab = "";

for (i = 0; i < dt.Columns.Count; i++)

{

Response.Write(tab + dr[i].ToString());

tab = "\t";

}

Response.Write("\n");

}

Response.End();

Answer / agrawars

better to concatenate data in the string builder with comma
seprated value and line change

and save string as a file and give it extension as .xls
This is the fastest way for export to excel.

It will be around 10 times faster then generale excel
writing and showing.

Answer / duddi

this is not correct question

How to Export Data to Excel?

4 Answers   Eastcom Systems,

---

How to use Client-side Script to Focus Controls in ASP.NET?

0 Answers  

---

Code for Sending E-Mail with System.Web.Mail?

2 Answers  

---

How to Create Scrollable Micro Windows?

2 Answers  

---

How to get the row index on checking a Checkbox in a ListView

1 Answers   TCS,

---

where is assembly are store

5 Answers   C DAC,

---

how to design a ListView control?

1 Answers  

---

Code for Getting Information About A File?

1 Answers  

---

How to Snap the Cursor to a Button?

1 Answers  

---

How to integrate the regional language in asp.net and c# like Telugu, Hindi etc,. send a sample program

3 Answers   Concept, NIIT, Wipro,

---

How to add checkbox to datagrid?

5 Answers  

---

Data Reader Vs DataSet

5 Answers   TCS,

---