Windows Forms .NET Framework Auth0 Excel Addin
I am looking for an add-in in Excel that takes a range, validates the data (i,e it is valid, needs dates and strings), and then sends it to a
cloud URL. It would also read from a database in the cloud.
Additionally, if you can do it, I am also looking for authentication in the plugin using Auth0. Can you do that too? So the functions for
uploading only appears after logging in.
Would you be able to do that?
So the tasks are essentially:
1. Validate and convert data to JSON and send to api endpoint to save to the DB
2. Read from api endpoint, get the JSON file, and convert to a range in Excel
If you can do that with authentication with Auth0, that would be even better.
I have attached an Excel sheet with the two functions and some examples, so you have an idea.