DocumentFormat.OpenXml Vs (Microsoft.Jet.OLEDB.4.0 & Microsoft.Ace.OLEDB.12.0) for Excel to DataTable in C# RRS feed

  • Question

  • User1094269964 posted

    Hi Friends,

    We are having a requirement to upload excel data to Oracle Table using ASP.NET MVC application  using oracle bulk upload.

    The asp.net mvc application will  list the list of tables from the oracle database. User will select table and click on download template.

    When the user click on download template what we will do is "select * from <selectedTable> where 1 >1"

    and we will construct DataTable in C# and the we will write excel file . User will download the excel and fill the data and upload the data using asp.net mvc application.

    What we plan to do is read the excel file and convert that into Datatable in C# and we plan to do bulk upload to Oracle table.

    To read the upload excel and convert that into Datatable which is the best choice in the below. 

    1) DocumentFormat.OpenXml



    Monday, August 24, 2020 3:30 PM


  • User-821857111 posted

    OpenXml is cross platform, so if you plan to create a .NET Core app, that should be your choice. You can't use either of the other libraries for creating Excel files, and Jet doesn't read xlsx files at all.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, August 24, 2020 3:57 PM