Create/change PowerPivot model from code C#/VB.NET

nixa333

New member
Joined
Jun 1, 2015
Messages
2
Reaction score
0
Points
0
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.

Thanx
 
Back
Top