Using OAuth AuthenticationCData Excel Add-In for Office 365 2019 - Build 19.0.7354
OAuth requires the authenticating user to interact with Office 365 using the browser. The add-in facilitates this in various ways as described below.
You will need to register an app to obtain the OAuthClientId and OAuthClientSecret.
Creating a Custom OAuth App
See Creating a Custom OAuth App for a procedure.