Hi,
I select my excel file with Excel Application Scope. I’m applying my filtering criteria with the Filter Data Table but it doesn’t show the headers when the Filter Data Table activity is applied. How can I add headers in Filter Data Table activity?
Note: Add Headers is checked in the Read Range activity.
After filtering, I need to read the data in column I in excel in order.
The filter data table uses known column header names. For example, if you know there is a column with a header of “Name”, and you wanted to get all of the “Stevens”:
If you dont know the name of the column, but it’s always the 3rd column, you can use the column index as well.
Or do you mean the headers are gone after filtering?
Hi,
Thank you for your answer.
@NervYerem
Or do you mean the headers are gone after filtering?
► Yes.
Hi @ridvanucok
The Header will never delete after applying the filter datatable.
Please find the attached sample code which will help you to read the specific columnI data after filtering data.
BlankProcess.zip (10.2 KB)
Hello,
Thank you for your comment. I already have an example. Here I split the data in the relevant cell, but excel cannot find the header.
@ridvanucok Could you please try to change the variable “row” with some other value inside nested loop.
I confirmed that filter data table shouldn’t remove the headers:
Can you see what the values of the data table are? You should be able to find it in your locals like I did above.
@NervYerem Yes, the header is coming after filtering. The error is in a different place then, but where. 
If you don’t mind could you please share workflow file with sample data to check thoroughly.
I am getting this error because I only read the I column with Read Excel after filtering. I fixed the problem by making the variable gd.Item(“0”).ToString.Split(","c) in my split activity. carelessness
