Read and write excel from Sharepoint folder

Product Forums Katalon Studio
,
1

Dear All,

I have a requirement, Do you have existing code to handle how to read and write excel sheet from KS if my excel sheet present in sharepoint.

2

I have never used SharePoint. But I found a document

https://support.microsoft.com/en-us/office/map-a-network-drive-to-a-sharepoint-library-751148de-f579-42f9-bc8c-fcd80ccf0f53

This tells you that you can map a Drive on your PC to a folder on Sharepoint. This would make a file on Sharepoint looks just similar to be a file on local disk for Katalon Studio.

3

We are in VPN which doesnt allow to map the drive. Any script to access the excel file programmatically from Sharepoint