Skip to main content
S_Elsayed7-Bedrock
7-Bedrock
Sep 3, 2023 1:02 PM UTC
Solved

How to extract data from an Excel Sheet in SharePoint?

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
pshashipreethamAnswer
19-Tanzanite
Sep 3, 2023 3:07 PM UTC

Hi @S_Elsayed,

 

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

 

Thanks,

Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
View in thread

3 replies

pshashipreetham
pshashipreetham19-TanzaniteAnswer
19-Tanzanite
Sep 3, 2023 3:07 PM UTC

Hi @S_Elsayed,

 

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

 

Thanks,

Translate
Shashi Preetham || +91 8099838801 || shashi@psptechhub.com
jensc17-Peridot
17-Peridot
Sep 4, 2023 12:09 PM UTC

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

Translate
PEHOWE17-Peridot
17-Peridot
Sep 12, 2023 1:56 PM UTC

@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.

Translate
Terms & ConditionsAccessibility statement