In my new robot, bot creates new excel file (.xlsx format) in a local folder (Documents folder) and then it should write a data table inside this excel file.
In attended mode everything works as expected.
In unatteded mode I’m getting this error:
“An unknown error occurred while trying to write a data table to a worksheet”
Do you have any idea what may cause such issue?
Many thanks for helping!
Cause 1: Excel installation was corrupt at the OS level, an indication is that when right-clicking anywhere and on New >, Microsoft Excel Worksheet was not displayed
Cause 2: Issue is observed after the upgrade of either Control Room or Excel, the Package version is not set to Default
Cause 3: Issue is observed after windows patch is installed and excel DLLs are corrupted because of which A360 is unable to connect with excel, but we are able to create/open excel files manually.
Cause 4: old Office installation registry settings remains active on system. Bot_Launcher log show the exception below.
Solution 1: Re-install Excel, then the "New > Microsoft Excel Worksheet" command appears, and the bot will run successfully.
Solution 2: Please set the default version for the Excel Advanced package.
Solution 3: Need to perform the online repair of office:-
Click Start, and then click Control Panel. Double-click Programs and Features. Click Microsoft Office 365, and then click Change. Select Online Repair, and then click Repair
Solution 4: need to install Office after using 'Office uninstall support tool'
1. adjust and use commands below on Powershell to confirm if same exception appears;
2. exception 'Unable to cast COM object[...]' will appear during execution if old settings are still available;
3. uninstall Office using Microsoft utility available on 'option 2' from URL below;
4. reboot device;
5. install Microsoft Office.