I'm trying to read/edit a SharePoint protected Excel file using NodeJS,
I have a user & password that have access to that file.
I used node-sp-auth, request-promise & gd-sprest, I was only able to get the URI of the file but I couldn't do much with it.
is it at least feasible? any other library suggestion?
To resolve this issue, I recommend you to use one of 2 approaches options:
Option 01: Develop a Web Service and share the captured SharePoint excel file with a resource like a base64 with this Web Service and on this Web Service develop the rules where will edit this Excel File; or,
Option 02: Using C# Programming and using CSOM Library, that will be more easy to get and edit you Excel file in one solution code;
For Office 365 you need to read the Microsoft Graph documentation and use @microsoft/microsoft-graph-client package.
