Can I access PowerPivot via a data access API?

Written by Denny Lee on 27 October 2010.

I recently got asked the question: Does PowerPivot have any data access APIs? Is there any way to to programmatically access the data store?