How to Export Data to Excel?
- 4 Answers
- 9139 Views
- Eastcom Systems, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 3 Yes | 0 No |
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();
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
how to design a ListView control?
how to track links visited in google using iframes
How to use Client-side Script to Focus Controls in ASP.NET?
How we implement the paypal in my website and how we make a payment through Credit Card.
Give coding for Implementing a Fixed GridView Header in ASP.NET?
What do you create for easier access of data?
How to Snap the Cursor to a Button?
Coding for .NET Delegates?
How to get Dynamically Linked Comboboxes Set?
Code for Document Validation in XML.NET?
How to send e-mail from an ASP.NET application?
16 Answers DataPoint, Infosys, Persistent, Radar, TCS, Wipro,
How to Bind Nested XML to a Repeater Control with Container.DataItem?
ASP.NET Code 
