Sharepoint development question, for complex list/app

Question

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.

Answer 1

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:

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

Get Embed Code:

Add Embed Web Part in SharePoint Online Modern Page:

Embed code in the web part and publish the page:

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.

Answer 2

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?

Answer 3

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.