none
saving parameters in excel web access webpart RRS feed

  • Question

  • Hi,

    Is it possible to save parameters in excel web access webpart? for eg, a user enters some parameters and he wants the next user to see what parametrs the previous user has entered..is this possible in excel services?

    please help??

    Monday, April 15, 2013 1:49 AM

Answers

All replies

  • Hi Cooltechie1234,

    Thank you for posting in the MSDN Forum.

    I'll consult my colleague on your issue. You'll be informed if there's any update.

    Thank you for your patience and understanding.

    Best regards,


    Quist Zhang [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Wednesday, April 17, 2013 1:02 PM
    Moderator
  • Hi quist,

    am thinking of couple of options:

    1) setting up a sharepoint list form (InfoPath) and then provision a InfoPath form webpart, which will then send values from the form webpart to the EWA. However, InfoPath form webpart "Send Data to" webpart connection is greyed out.

    2) use some javascript which will access the dom of the input parameters and then create a list item upon a button click. The created list item will have a user name entered by the user and the list of all parameter values.

    and a dropdown with a list of users which upon selection would show all the parameters in the parameter task pane.

    Any thoughts?

    Thursday, April 18, 2013 6:06 AM
  • Hi Cooltechie1234,

    You could save your parameters as custom document properties to the Excel file. You would read/write the properties using Open XML. 

    Here is an similar example for Word:

    http://msdn.microsoft.com/en-us/library/office/bb308936(v=office.12).aspx

    Regards,

    Dennis

    Thursday, April 18, 2013 6:43 PM