I have a pivot table in excel that I want to read the raw data from that table into python. Is it possible to do this? I do not see anything in the documentation on it or on Stack Overflow.
If the community could be provided some examples on how to read the raw data that drives pivot tables, this could greatly assist in routine analytical tasks.
EDIT: 
In this scenario there are no raw data tabs. I want to know how to ping the pivot table get the raw data and read it into python.
First, recreate raw data from the pivot table. The pivot table has full information to rebuild the raw data.

Make sure that none of the items in the pivot table fields are hidden -- clear all the filters and Slicers that have been applied.
The pivot table does not need to contain all the fields -- just make sure that there is at least one field in the Values area.
Show the grand totals for rows and columns. If the totals aren't visible, select a cell in the pivot table, and on the Ribbon, under PivotTable Tools, click the Analyze tab. In the Layout group, click Grand totals, then click On for Rows and Columns.
Double-click the grand total cell at the bottom right of the pivot table. This should create a new sheet with the related records from the original source data.

Then, you could read the raw data from the source.
Getting the Raw Data Out of an Excel Pivot Table in Python