reading from excel Best approach in .net RRS feed

  • Question

  • User2060565753 posted

    I know approaches like oledb, Excel object model.

    Wanted to know whats the best approach

    Monday, June 3, 2013 6:34 AM


  • User269602965 posted

    OLEDB is fine way to go, but sometimes you get unexpected results and may have to modify (prepare) your data on the Excel side or handle a data transformation on the .NET side.  The main issue is what you see in a spreadsheet is a FORMAT and not what Excel may be storing in the background and exports to OLEDB.  Search this Forum for Excel and OLEDB keywords and you will get an understanding of some recurring issues.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 3, 2013 11:03 PM

All replies