I have a requirement for a bot to open an Excel file using a SharePoint URL. The bot needs to add a row to the file with a few cells of data, and save.
Firstly, when I go to the SharePoint URL I am prompted with the Office 365 portal to login with username password but having difficulties automating this. Does anybody have any suggestions for this? Sometimes I have to click the previous username from list, other times type in username, and the selectors are always valid even if not visible, so it’s difficult to automate the login process.
Also, I notice in Excel web using the SharePoint URL I am unable to click on individual cells. How can I have the bot to interact with the Excel file in web?