Search code examples
c#exceljet

Reading pivot table with c#

I am trying to read an excel-sheet containing a pivot table generated by macros with the following connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=path;
Extended Properties="Excel 8.0;HDR=NO;";

the problem is that the values doesn't appear in my dataset, only labels of columns and lines, but not necessary values.

Any idea to read a such file?

Solution

  • I don't know why, but by changing the provider to Provider=Microsoft.ACE.OLEDB.12.0, data is read correctly.

    the fill dataset is slower, i but I got what i'm looking for thanks