Unable to open excel spreadsheet in automation anywhere

I am using Automation Anywhere for inserting values into an excel file. I used thie below code for opening the spreadsheet.But the spreadsheet is opening in excel app instead of Microsoft Excel in my computer. I don't have the license for Outlook Excel App.

Excel: Open Spreadsheet "C:\Users\my_user\Documents\xyz.xlsx".ActiveSheet:"Default".Contains Header,Session:Default

Can anyone help me on this issue?


Excel open problem, I am facing error below while using Open Excel Spreadsheet command. please this makes it so my bot is unable to refresh the session due to mismatch name. I am using Automation Anywhere for inserting values into an excel file. I used thie below code for opening the spreadsheet.But the spreadsheet is opening in excel app instead of Microsoft Excel in my computer. I don't have the license for Outlook Excel App.


Try this:

Create File "C:\Users\cxcioba\Desktop\Test.xls"
Excel: Open Spreadsheet "C:\Users\cxcioba\Desktop\Test.xls".ActiveSheet: "Default". Session: test

From your code I'd change to *.xls

Open Spreadsheet, Interop.Excel._Application'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{000208D5-  The Automation Anywhere services team has worked with companies of all sizes to automate their business processes for them, help discover new automation ideas, and maximize ROI.


If you are trying to open in that way . go to c drive in your machine and look for the microsoft excel in the program files . you can use the same .exe in " Open program file " command

Unable to open excel file from client., I would recommend: Open regedit -> navigate to Computer\​HKEY_CURRENT_USER\Software\Microsoft\Office\(your version here:probably  Unable to use Excel as Database in Automation Anywhere 10. 0 votes . 1 view. asked Jul 11, Unable to open excel spreadsheet in automation anywhere. asked Jul 11,


Unable to open excel spreadsheet in automation anywhere, The built-in Automation Anywhere Excel open command does not explicitly drive fails to open the Excel file on a network drive although the file is present. Use the Excel command to transfer data to and from Microsoft Excel spreadsheets. Overview. The Excel command enables you to automate many of the repetitive tasks that involve spreadsheets. Some common scenarios include: Copy data from one Excel spreadsheet to another. Extract data from an application to an Excel spreadsheet.


RPA Lessons Learned: Opening Excel Files on Local and Network , Choose less data or close other applications. The error occurs when you: Open or save an Excel workbook; Open an Excel workbook that  @d3mo (Customer) If there is not enough memory available to keep the excel with all its edits in memory and still perform manipulations such as sorting, dragging, scrolling, and so on quickly along with any other applications that are running, then excel moves part of its code that is not being used or part of the file that is not being edited from memory to disk.


Excel cannot complete this task with available resources error in , To do that, drag the Open Spreadsheets command from the Excel section. Step 3: Mention the path of the first spreadsheet( from where you have  Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space. • To make more memory available, close workbooks or programs you no longer need. • To free disk space, delete files you no longer need from the disk you are saving to.