Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to Export Data to Excel?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Coding for Synchronizing Cache Access in ASP.NET?

3593


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

2512


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.

2662


how to track links visited in google using iframes

2695


Code for Communicating over Sockets?

2308


Code for Creating a Form Using PlaceHolder Controls?

2781


Code for Document Validation in XML.NET?

2334


How to get Dynamically Linked Comboboxes Set?

2407


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

3599


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

2943


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

3928


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

2944


ArrayList declaration in .net

3184


How to use Client-side Script to Focus Controls in ASP.NET?

2921


Coding for .NET Delegates?

2499