• State Not Answered
  • Replies 2 replies
  • Subscribers 11 subscribers
  • Views 99 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Robotic Process Automation (RPA)

Getting error while opening XLSB workbook

manavl5697

[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

Parents
  • 0
    Certified Associate Developer

    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.
Reply
  • 0
    Certified Associate Developer

    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.
Children
No Data

© 2024 Appian. All rights reserved.