Column does not exist.........filter activity

i have excel in which i am tring for filter activity. but it showing error “column does not exist”. I think its because my all column staring from row12.if this is the reason then what should i do?

@Hemant_Deshmukh

In filter activity

In the range give 12th row range

Excel.Sheet("SheetName").Range("12:12")

Cheers

in read range activity set startingCell = A12 , where A is the starting column (can changeif needed)

@Hemant_Deshmukh
while reading excel set the range as “A:12”
as shown in below attached pic-
image

Hello @Hemant_Deshmukh

  1. Read Range: Read the Excel data into a DataTable, let’s call it “excelDataTable.”

  2. Assign: Create a new DataTable to store the filtered data, e.g., “filteredDataTable.”

  3. Filter Data Table:

    • Input DataTable: excelDataTable
    • Output DataTable: filteredDataTable
    • Filter Wizard: Set your filter conditions here, for example:
      Column: [YourColumnHeader]
      Operation: “equals”
      Value: “YourValue”
  4. For Each Row: Loop through the filteredDataTable to process the filtered data.

Thanks & Cheers!!!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.