How to call excel sheet in asp.net

[arunasingh]

sir

I want to know how to call any exel sheet in asp.net

[serkan sendur]

try this link :
http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/

[Bhaarat]

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

[arunasingh]

thank u sir this will helpme a lot

[sierrainfo]

Try this following links. Hope it will help you.

http://www.beansoftware.com/asp.net-tutorials/generating-excel-reports.aspx

http://www.dotnetspider.com/resources/15591-How-read-EXCEL-data-file-asp-net.aspx