Verify if something has been filtered in Excel

Help StudioX
,
1

Hi, I would like my robot to verify if something has been filtered in Excel. It verified whether the line after the header was empty or with text. If he filtered the text in a row, he has to do something, if he hasn’t filtered it, the line is empty, he has to do something else. Any ideas?

2

Do 2 read ranges.

  • 1 allowing data to be filtered out
  • 1 reading through all data unfiltered.

Result should be 2 datatables. If they have a equal number of rows, there is no filter, if there is a difference some form of filter is active.

1 Like
3

@sullivanne

Excel Application Scope
    Filter activity
    Read Range -> filteredDataTable
    If `filteredDataTable.Rows.Count > 0`
        If `String.IsNullOrWhiteSpace(filteredDataTable.Rows(0)(0).ToString)`
            // Perform action for empty line
        Else
            // Perform action for non-empty line
    Else
        // Perform action if no data is filtered
1 Like