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

Code for Presenting Parent/Child Data in a Data Grid Row?

0 Answers   TCS,

---

Give coding for Exception Handling Techniques in ASP.NET?

3 Answers   Microsoft,

---

hold checkbox values

4 Answers  

---

how to create a search bar which access data from various websites and retrieves the data

0 Answers  

---

how the value of label is printed through a button in asp.net web application

3 Answers  

---

---

where is assembly are store

5 Answers   C DAC,

---

How to Export Data to Excel?

4 Answers   Eastcom Systems,

---

working with fileUpload ?

1 Answers  

---

Code for Creating a Form Using PlaceHolder Controls?

0 Answers   Arena, JSA,

---

ArrayList declaration in .net

0 Answers  

---

How to send e-mail from an ASP.NET application?

16 Answers   DataPoint, Infosys, Persistent, Radar, TCS, Wipro,

---

Code for Communicating over Sockets?

0 Answers  

---