Workbook Activities Results In System.IndexOutOfRangeException For Certain Excel Files

While using a workbook Excel activity, (e.g. read cell write cell, read range, write range, etc.), System.IndexOutOfRangeException occurs with error " Index was outside the bounds of the array" .

Certain Excel data results in this exception.

Workarounds can be one of these.

  1. Use Excel Application Scope.
  2. Use UiPath.Excel.Activities package older than or equal to 1.2.6256.15131