cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

How to extract data from an Excel Sheet in SharePoint?

S_Elsayed
6-Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @S_Elsayed,

 

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

 

Thanks,

Shashi Preetham,
Email: psp316r@outlook.com,
Mobile: +91 8099838001.

View solution in original post

3 REPLIES 3

Hi @S_Elsayed,

 

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

 

Thanks,

Shashi Preetham,
Email: psp316r@outlook.com,
Mobile: +91 8099838001.
jensc
17-Peridot
(To:S_Elsayed)

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

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

Top Tags