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

Data Reader Vs DataSet

5 Answers   TCS,

---

Give coding for Implementing a Fixed GridView Header in ASP.NET?

1 Answers  

---

where is assembly are store

5 Answers   C DAC,

---

Code for Getting Information About A File?

1 Answers  

---

How we use ajax in asp.net through javaScript. Please givee me an example.

0 Answers  

---

how to design a ListView control?

1 Answers  

---

i have a gird with columns all are coming from database,this will bind in item templete in gridview as textboxex.and i have button below named Update.i want to update all the records in the grid,but if user change the value of one textbox,what is the easy way 2 do this

0 Answers   Crompton Greaves,

---

How to Bind Nested XML to a Repeater Control with Container.DataItem?

0 Answers  

---

Code for Using Keyboard Events?

0 Answers  

---

How to Snap the Cursor to a Button?

1 Answers  

---

Give coding for Exception Handling Techniques in ASP.NET?

3 Answers   Microsoft,

---

What is the code of Password Recovery or Forget your password? Plz tell in c # language.

0 Answers  

---