ASP.Net File Upload Control read Excel WorkSheet Names using OledbConnection Class in C# RRS feed

  • Question

  • Hi,

    I have an issue while uploading the Excel sheet from the Asp.Net Upload Control.
    Here is my scenario.

    1) I am using my Asp.Net Upload Control to read the excel sheet data and worksheet names  in the Uploaded Spreadsheet.
    2)I am creating the folder in the local machine and saving the uploaded file in Submit button.
    3)Then I am reading the data of Excel Spreadsheet from the saved file in local machine using OledbConnection class in C#.

    I dont want to save the Uploaded file in the local machine and read it.
    Is there any possibility to read the Uploaded Excel File without saving it in Local Machine using Upload file control.

    Note : According to my requirement we can’t use the Excel object from office.Excel.Interop dll’s. We should implement with the help of OledbConnection class only.

    Can anybody please help me regarding this problem.


    • Edited by Rajkamal29 Monday, July 27, 2009 7:07 AM added the text
    • Edited by Mike Walsh FIN Monday, July 27, 2009 7:10 AM time pressure removed
    Monday, July 27, 2009 7:00 AM


All replies