How to extract data from an Excel Sheet in SharePoint?

[S_Elsayed]

Hello!

I have an excel sheet that is on Sharepoint. I want to create a service that gets that data from the sheet, and then perform filtering, aggregation, etc.

Could someone please tell me how I can do that?

Thank you.

[pshashipreetham · Accepted solution]

Hi @S_Elsayed,

Please check this Article from 2022:
Solved: Accessing data from SharePoint - PTC Community

Thanks,

[jensc]

Hello,

Not sure if my post could be of help for you?
It doesn't go into too much detail on how to read files from sharepoint, but perhaps enough for you to start.
How to get access to your files on sharepoint (getting bearer token etc) should be pretty straight forward from reading sharepoint documentation.

Regards,

Jens

[PEHOWE]

@S_Elsayed , To access an Excel file directly may require the creation of a ThingWorx Extension. The Apache POI is a Java API for accessing Microsoft Document.

Depending on your needs you can include this library and access the Excel data using this open source library. 

Hope this helps.