943,578 Members | Top Members by Rank

Ad:
  • ASP.NET Discussion Thread
  • Unsolved
  • Views: 1200
  • ASP.NET RSS
Dec 17th, 2008
0

How to call excel sheet in asp.net

Expand Post »
sir

I want to know how to call any exel sheet in asp.net
Similar Threads
Reputation Points: 10
Solved Threads: 0
Light Poster
arunasingh is offline Offline
39 posts
since Dec 2008
Dec 19th, 2008
0

Re: How to call excel sheet in asp.net

Featured Poster
Reputation Points: 854
Solved Threads: 127
Banned
serkan sendur is offline Offline
2,057 posts
since Jan 2008
Dec 21st, 2008
0

Re: How to call excel sheet in asp.net

Use this..

u may get data from ur excelsheet


 Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim DBConnection = New OleDbConnection( _
         "Provider=Microsoft.Jet.OLEDB.4.0;" & _
         "Data Source=" & Server.MapPath("~/datame.xls") & ";" & _
         "Extended Properties=""Excel 8.0;HDR=Yes""")
        DBConnection.Open()

        Dim SQLString As String = "SELECT * FROM [Sheet2$] "
        Dim DBCommand = New OleDbCommand(SQLString, DBConnection)
        Dim DBReader As OleDbDataReader = DBCommand.ExecuteReader()

        GridView1.DataSource = DBReader
        GridView1.DataBind()
        DBReader.Close()
        DBConnection.Close()

    End Sub
Reputation Points: 10
Solved Threads: 2
Newbie Poster
Bhaarat is offline Offline
6 posts
since Nov 2006
Dec 22nd, 2008
0

Re: How to call excel sheet in asp.net

thank u sir this will helpme a lot
Reputation Points: 10
Solved Threads: 0
Light Poster
arunasingh is offline Offline
39 posts
since Dec 2008
Dec 22nd, 2008
0

Re: How to call excel sheet in asp.net

Reputation Points: 10
Solved Threads: 9
Junior Poster
sierrainfo is offline Offline
144 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP.NET Forum Timeline: ASP site not working when uploaded
Next Thread in ASP.NET Forum Timeline: What are the differences between ASP.NET and ASP?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC