how to read pivottable excel using c#?

I am developing add-in for excel and trying to read pivot tables but found no access to pivot tables from the worksheet , strangely pivot table can be reached 开发者_如何学JAVAfrom non add-in projects , I will be grateful if any one give me some info or code.

I assume you've checked the Worksheet.PivotTables property?!