Sharepoint development question, for complex list/app

dp01110 1 Reputation point
2020-11-26T10:20:55.077+00:00

Hello,

my company is currently using Sharepoint. We have a spreadsheet in Excel currently, with all customers, and all products that the customers currently have or have not.

What I'm looking for is to be able to display this list dynamically on Sharepoint.

To be able to see the list of customers, be able to click one - maybe it opens a new page or pop-up then have the list of all the products they either have or don't. This would then also need to be filterable.

I'm pretty sure from exploring Sharepoint Lists that Out of the Box Sharepoint isn't able to do what I'm looking for. Therefore the need to develop something.

My problem is knowing where to start in the development phase. Is it possible in Visual Studio to change web parts in Sharepoint-Online?

Just looking for a bit of direction really. If anything here isn't clear please ask, I'd really like to solve this problem.

Thanks in advance.

SharePoint Server Development
SharePoint Server Development
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Development: The process of researching, productizing, and refining new or existing technologies.
1,608 questions
{count} votes

3 answers

Sort by: Most helpful
  1. Jerryzy 10,571 Reputation points
    2020-11-27T02:28:18.107+00:00

    Hi @dp01110 ,

    If want to display Excel SpreedSheet dynamiclly in SharePoint Online, just need to use Embed Web Part, no need to develop custom web part/feature to achieve:

    Upload a file into SharePoint Library:

    43096-1.jpg

    Open this Excel File in Excel and click File->Share->Embed:

    43133-2.jpg

    Get Embed Code:

    43134-excel2-thumb.jpg

    Add Embed Web Part in SharePoint Online Modern Page:

    43030-excel3-thumb.jpg

    Embed code in the web part and publish the page:

    43182-5.jpg

    This way can display the excel sheet data dynamically, after editing the data in Excel Online, the Embed Web Part will also refresh to the latest data.

    Reference:

    Embedding an Excel Spreadsheet in to a Modern SharePoint Page

    Hope this can be helpful to you and get you the right direction.

    Thanks

    Best Regards


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

  2. dp01110 1 Reputation point
    2020-11-27T07:49:49.103+00:00

    I'm aware of the but I need to do more than just display the data.

    I need to ineract with it, and for every row for example, I would like it to maybe open up to a new page for each row to display more info.

    I guess what I am looking for is a way to customise and develop on the structure of lists. Is that possible in Visual Studio for example?

    0 comments No comments

  3. Jerryzy 10,571 Reputation points
    2020-11-27T09:16:27.297+00:00

    Hi @dp01110 ,

    If want to do more action and display more data in a new form, I suggest you could develop a Cosnole Application which could import Excel data into SharePoint list:

    Using CSOM to Import CSV Files Into Lists in Office 365/SharePoint Online

    Then you can create a windows Task Scheduler to trigger this Console Application so that it will keep the data dynamically.

    After importing the data into SharePoint list, you can use all SharePoint list feature like open item in View Form, filter, sort and so on.

    Thanks
    Best Regards


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.