Reading all excel sheets in Asp.net? RRS feed

  • Question

  • User-431814568 posted

    I have 1  excel file 2007 that contains  10 sheets

    First sheet  Name : Remarks that contain only one column for remarks

    the other 9 sheets name : Date1 Date2 Date3 Date4 Date5 Date6 Date7 Date8 Date9

    each of the 9 sheets has 2 columns:  Product Description  and Qantity


    I am using

        Using connection As New OleDbConnection(excelConnectionString)
                    Dim command As New OleDbCommand("SELECT Product_Description,Qantity FROM [sheet1$]", connection)



    please help me I need to know how can to read all the  10 sheets ?



    Saturday, February 19, 2011 8:10 AM


All replies