How to Export Data to Excel?
- 4 Answers
- 9583 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 |
Common UI for Multiple web applications. Suppose there are 35 websites using same third party controls.These 3rd party controls are made together that all 35 websites can use these controls.If we put all 3rd party controls and use its dll in 35 websites,only class files will be accessable. But I want to use CSS,images also in all 35 websites. how I can design the N-tier solution for this project.
working with fileUpload ?
Coding for .NET Delegates?
Code for Communicating over Sockets?
How we implement the paypal in my website and how we make a payment through Credit Card.
How to get Dynamically Linked Comboboxes Set?
Coding for Synchronizing Cache Access in ASP.NET?
How to get the row index on checking a Checkbox in a ListView
Code for Getting Information About A File?
Give coding for Exception Handling Techniques in ASP.NET?
how to track links visited in google using iframes
how to create a search bar which access data from various websites and retrieves the data
ASP.NET Code 
