Transer Open XML file into Dataset RRS feed

  • Question

  • I am trying to read the values of an excel file using the OPEN XML API, however I'm finding that the documentation is less than helpful.

    I have a Strongly Typed DataTable and need to insert data into it from an excel file.  What is the best way to do this? 

    In years past I would just load the Interop objects and loop through each cell value, but there doesn't appear to be a way to do that so far.

    Thanks in advance.


    Tuesday, July 9, 2013 6:40 PM