How to Export Data to Excel?
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 |
Code for Getting Information About A File?
hold checkbox values
where is assembly are store
Coding for Synchronizing Cache Access in ASP.NET?
How to Bind Nested XML to a Repeater Control with Container.DataItem?
how to convert Dataset to Object Array or list in c# .net
What do you create for easier access of data?
how to track links visited in google using iframes
Coding for .NET Delegates?
Code for Creating a Form Using PlaceHolder Controls?
how to create a search bar which access data from various websites and retrieves the data
Code for Using Keyboard Events?