Skip to main content
S
S_Elsayed7-Bedrock
7-Bedrock
September 3, 2023
Solved

How to extract data from an Excel Sheet in SharePoint?

  • September 3, 2023
  • 3 replies
  • 1509 views

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.

Best answer by pshashipreetham

Hi @S_Elsayed,

 

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

 

Thanks,

3 replies

pshashipreetham
18-Opal
pshashipreetham18-OpalAnswer
18-Opal
September 3, 2023

Hi @S_Elsayed,

 

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

 

Thanks,

J
jensc17-Peridot
17-Peridot
September 4, 2023

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

P
PEHOWE17-Peridot
17-Peridot
September 12, 2023

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

Terms & ConditionsAccessibility statement