Nader Sghir Nader Sghir -4 years ago 88
C# Question

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?

Answer Source

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

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download