I have created a BOT which needs to open excel sheet and then perform task. It is running smoothly on office 2016, however recently I have upgraded to office 365, now BOT is unable to open the excel sheet from my desktop and throwing error and then stops by giving message to install excel application .
First of all I like to thank you for looking at the issues and giving suggestion for possible solution.
The bot just need to read excel sheet from desktop. When I was using office 2016 its able to read that, however we I upgrade the package to office 365, its throwing error.
Can you guide me how to use workbook activities to read an excel sheet from desktop. I have never worked around workbook activities.
I have attached the screenshot for the activity which I am using to read the excel file from desktop.
Please help me to solve this, I am stuck in this from long time and not get any solution from anywhere and this is the sole reason I have joined the community in hope for any possible solution.
Don’t use excel application scope. Use read range
to read the sheet.
put the path of the sheet present in the location.
Put a output datatable activity after that .
then use message box or write line activity
I have updated the automation as suggested by you and glad to say that this has resolved the issue and now the automation is running fine and even more fast without even opening the excel file its getting the data from it. I was not aware that this minor change can work great.
I am really very thankful to you for helping me out of this problem.
I wish you all the success, happiness, and joy in life.