View Full Version : Create/change PowerPivot model from code C#/VB.NET

2015-06-03, 09:52 AM
Hi guys, I'm havin a problem with powerpivot and .NET. I'm a asp.net developer, but not really experienced in Excel.
What I need is the following: Having a created excel document, I want to open it in .NET (c# or vb.net), create powerpivot model in it and fill it with data. Another option is to already have powerpivot model created, but to change sql command which fills the data for it. I want to do all of that programatically in code.
My goal is to have an excel file, with power pivot data, but the data is fetched with sql stored procedure, which returns different data for different users. So when user requests the report, I want to fill the model with data for that user, and send the file to him. I hope I'm being clear here. If not, please contact me, I would really appreciate help with this.
PS. I have both excel 2010 and 2013 for testing.


2015-06-09, 09:27 AM
So no help on this one?