Find First/Last Data Row

Finds and returns first and last data rows within given range.

Input

• Source: The range where the first/last data row finding operation will be applied.
  • Type: System.String
• Column Name: The name of the column where the operation will be applied
  • Type: System.String
  • Required
• Blank Rows to Skip: It moves to the next row when encountering an empty row.
  • Type: System.Int32
  • Required
• First Row Offset: If you want to start after a specific row, enter the information of the row to start after.
  • Type: System.Int32
  • Required
• Last Row Offset: If you want to check until a specific row, enter the information of the row to be checked.
  • Type: System.Int32
  • Required

Options

• Configure Last Row as: Configure whether we want to return the last row as the last populated row or return the first row that is empty.
  • Type: System.Int32
  • Required
  • Dropdown Options:
    • Last Populated Row
    • First empty row
• Has Headers: If checked, the first row in the entered range is considered as a header row and skipped.
  • Type: System.Boolean
  • Required

Output

• First Row Index: The index of the first row
  • Type: System.Int32
  • Required
• Last Row Index: The index of the last row
  • Type: System.Int32
  • Required

Details

• This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.