Error message: An unknown error occurred while trying to write a data table to a worksheet

@Kasia 8214 

Cause

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.

ERROR [BotRunner-6a1551e8-b77c-44bc-8c84-322f7225f7b8_f01d1a725e302d15] - com.jniwrapper.win32.jexcel.Application {deploymentId=6a1551e8-b77c-44bc-8c84-322f7225f7b8_f01d1a725e302d15, traceId=f01d1a725e302d15} - error(SourceFile:69) - java.lang.reflect.InvocationTargetException: nullCaused by: com.jniwrapper.win32.com.ComException: COM object method returns error code: 0x80029C4A; Error loading type library/DLL.

Resolution/Workaround

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;

$file = "D:\CSV\Dummy.xlsx" #change path accordingly$sheetName = "Sheet1"$excel = New-Object -com Excel.Application$excel.Visible = $True$wb = $excel.workbooks.open($file)

  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;

https://support.microsoft.com/en-us/office/uninstall-office-from-a-pc-9dd49b83-264a-477a-8fcc-2fdf5dbf61d8

  4. reboot device;
  5. install Microsoft Office.

To resolve the error “An unknown error occurred while trying to write a data table to a worksheet” in unattended mode, try the following steps:

1. Reinstall Excel to ensure the installation is not corrupt.
2. Set the default version for the Excel package in your automation settings.
3. Perform an online repair for Office via Control Panel under Programs > Features.
4. If the issue persists, use Microsoft's Office Uninstall Support Tool, reboot, and reinstall Office.

These steps address potential DLL or registry conflicts that may disrupt the bot. learn more