locked
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)

                    connection.Open()

     

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

     

     

    Saturday, February 19, 2011 8:10 AM

Answers

All replies