Skip to main content
M
manavl5697
March 15, 2024
Question

Getting error while opening XLSB workbook

  • March 15, 2024
  • 2 replies
  • 0 views

[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.

    2 replies

    davidj137213
    davidj137213
    March 15, 2024

    Could you check if there is more information in logs please?

    srmm0001
    srmm0001
    April 2, 2024

    To resolve the error when opening an XLSB file with Appian RPA:

    1. Confirm that Microsoft Excel is installed and properly configured on the RPA agent's machine.
    2. Ensure the XLSB file is not open elsewhere or locked by another process.
    3. Verify that the "Open Workbook" component supports XLSB files.
    4. Check that you have a valid license for both Excel and the RPA component.
    5. Update Appian RPA and Excel to the latest versions if compatibility issues are suspected.
    6. Inspect the Excel file to ensure it's not corrupted.
    7. Adjust Excel's Trust Center settings to allow automation.
    Terms & ConditionsAccessibility statement