EPPlus reading Pivot Table Data

Aug 31 2021 12:15 PM

Hi ,

I am using EPlus Package in Visual Studio 2019. I need some help in reading an xls sheet which contains Pivot Table. I want to read this Pivot Table data and Process the data further. Pls help me.

FYI, So far I am able to read a cell which is not part of Pivot table using the below code. I can see the text value in myvalues.

var myvalues = ws_pivot.Cells[1, 10].Value?.ToString().Trim();

 

But the same code does not work if i am reading a data from a pivot table (rows/columns) and it returns null. Pls help me . Pls provide me an example to read the Rows and Columns of a Pivot table.

Appreciate your help asap as i have to complete some reading by tomorrow. Thanks in adnvance for your kind help.

 

Thanks & Regards
Vijay.S

(+917829044007)


Answers (1)