locked
Export data to Excel and enable data refresh from within Excel RRS feed

  • Question

  • User488731944 posted

    Hello,

    We want to implement a data export to excel and refresh data from within Excel - the exact same behavior found in SharePoint Lists.

    In SharePoint, we can export any list to excel. Once exported, it has a data connection already generated to the source list.
    When user clicks on refresh button for this data connection, excel fetches the latest data from SharePoint and populates it in the excel.

    We want the exact same functionality in our ASP.NET MVC application.
    If there are any third party solutions available, please suggest and we can go with that.

    Thanks.

    Thursday, December 6, 2018 7:56 PM

All replies

  • User1520731567 posted

    Hi preetkamal110,

    According to your description,

    Let MVC project and Excel interact in real time, in fact, it is not safe.

    This requires Excel to have the ability to change database data.

    I suggest you could move to office 365 forum for help:

    https://techcommunity.microsoft.com/t5/Office-365/bd-p/Office365General

    Best Regards.

    Yuki Tao

    Friday, December 7, 2018 8:44 AM
  • User-474980206 posted
    You have two issues.

    1. Download your data as an excel spreadsheet, and include macros to access your data. See open xml sdk for this:

    https://docs.microsoft.com/en-us/office/open-xml/open-xml-sdk

    2. Support an excel connection to your data. Excel has built in support to access a SharePoint lists and numerous data source. You will need to expose your data via one of these sources.

    Your simple option is to expose your data to a SharePoint list. See. Share points data connector.
    Saturday, December 8, 2018 1:20 AM