Hi Harneet,
We have only support of Preserving Pivot Tables in Excel sheet, but we can retrieve the information from the pivot Tables/Pivot Charts using XlsIO.
Here with i attach a Sample.
PivotTables_2500.zip
Please take a look at this sample and let me know if you have further questions.
Best Regards,
Seetha
>How can i retrieve information on Pivot Tables/ Pivot Charts?