Getting error while opening XLSB workbook

manavl5697 1 month ago

[ERROR] 2024-03-15 06:55:01 01m 01s (0h) - Error executing action [exceljacob->open-create-workbook]
Invoke of: Open
Source: Microsoft Excel
Description: Open method of Workbooks class failed

Hi, i am getting this above error when i am trying to open XLSB workbook through Appian RPA and for this i'm using "Open Workbook(license required)" component.

Discussion posts and replies are publicly visible

0 David J (NTT DATA)
Certified Lead Developer
1 month ago

Could you check if there is more information in logs please?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 SRINI
Certified Associate Developer
25 days ago
To resolve the error when opening an XLSB file with Appian RPA:

Confirm that Microsoft Excel is installed and properly configured on the RPA agent's machine.

Ensure the XLSB file is not open elsewhere or locked by another process.

Verify that the "Open Workbook" component supports XLSB files.

Check that you have a valid license for both Excel and the RPA component.

Update Appian RPA and Excel to the latest versions if compatibility issues are suspected.

Inspect the Excel file to ensure it's not corrupted.

Adjust Excel's Trust Center settings to allow automation.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel