i need help in connecting to excel file in studio web . i tried connecting but getting an error.
Failed to create the connection. Please close this browser tab and try again.
Thanks for the update! Yes — for connecting Excel in Studio Web, you need to use a Microsoft account (like Outlook.com, Hotmail, or a work account with Microsoft 365 access).
Since you’re currently using a Gmail account, it won’t work because it doesn’t support Microsoft’s Excel Online integration.
when i click on connect to microsoft , it lands in sign in page , when i give the account details getting the error. Now i tried with outlook account but no luck
If you’re still getting the 403 error even with an Outlook account, follow these steps to resolve it:
Use a Personal Microsoft Account
Make sure it’s a personalOutlook.com or Hotmail.com account — not a work or school account, as those often restrict API access needed by Studio Web.
Clear Browser Sessions
Sign out of all Microsoft accounts.
Clear browser cache and cookies.
Close all tabs and reopen Studio Web in an incognito window.
Reconnect to Excel
Try connecting again. When prompted, accept all permissions requested by UiPath.
For using excel online you need a non personal o365 license
If gmail..one way you can do is send an email with attachment excel then you have workbook activities like read range ehich dont need any license …that can be used to read the data into datatable and then loop on datatable as you need
Or you can alao try the same by kewping in gdrive and use download file and then read…or keep data in gsheet