joemaller/ms-graph-excel-experiment

Working through and expanding a Microsoft example for connecting to MS-Graph and eventually writing to an Excel sheet

Add Row to Excel Spreadsheet on Sharepoint

This has been incredibly frustrating.

Ultimately, all I want to do is append a row to this Excel file, on OneDrive: Contact Form Test Sheet.xlsx

Goals:

• Connect to Azure using the Graph API Console app
• Call other API endpoints (not just getUsers)
• Get Users' Drives (OneDrive)
• List contents of Users' Drives
• List directory/contents of a Drive/DriveItem
• List the file or file attributes for the target Excel sheet
• Append a row to an excel sheet
• Send an email

Additional stuff:

• Replace Axios with native Fetch API
• Actual API error messages
• Convert to ES Modules

References and things to followup on

• The PnP library might make some of this easier? Or not?
• Also the @microsoft/microsoft-graph-client library