Skip to main content
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.

Sep 3, 2023 3:07 PM UTC

Hi @S_Elsayed,

 

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

 

Thanks,

3 replies

Sep 3, 2023 3:07 PM UTC

Hi @S_Elsayed,

 

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

 

Thanks,

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

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.