How to pass data to new online excel workbook using C# ? RRS feed

  • Question

  • Hi,

    For a desktop excel client and add-in, I am able to prepare the data, create the excel object and open a new workbook with data pre-populated in the same. 

    Similarly, I am trying to develop an Excel online add-in, where I need to pass the data to online excel worksheet and open the worksheet from an external (C#) application by URL. 
    The data should be prepopulated or with minimum clicks, I should be able to fetch the data from the database.

    Currently, as a workaround, I am saving the data(that has to be exported) to database, and then open workbook in online excel, 
    where I have to click-open the add-in and further coded logic fetches the data from the database and with help of Office.js and populate the sheet.

    It would be great if somebody could help me in implementing a better approach to achieve the same.

    Thanks & Regards,

    Pratik Prakash.

    Monday, August 21, 2017 4:24 PM