Hi Tom,
Sorry for the delay in responding. Currently we provide support for preserving Pivot Tables in Excel sheet and retrieving information from the pivot Tables.
Here is a sample for your reference:
Pivottable.zip
Please take a look at the sample above and let me know if you have any questions.
Regards,
Melba