Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    So no help on this one?

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •