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)