How to unselect the #N/A
Have you selected Use filter option in Read Range Activity ?
If yes then uncheck and try then it will ignore filter and will read all the data.
It can be done once after getting the datatable
That is using excel application scope and read range activity we can get the datatable output named dt
And to filter all records without N/A value then this thread would help you
The Use filter is uncheck
Then it should read whole data.
But i want to uncheck just the #N/A
Then this would help us
@Carla_Marie_Barte I guess We just need to use Filter Datatable Activity and use Filter Operation as Does Not Contain ‘#N/A’.
I used that at first but it doesn’t work
@Carla_Marie_Barte What was the Result, It didnt Filter at All, or did it Filter some rows?
No nothings happen
I just want to uncheck the #N/A so that only the numbers will appear on the excel file
@Carla_Marie_Barte Can you tell us What are the Operations that you are performing currently
Use invoke vba for unselect #N/A
’ Macro1 Macro
ActiveSheet.Range("$A$1:$A$13").AutoFilter Field:=1, Criteria1:="<>#N/A", Operator:=xlFilterValues
choose your range accordingly by passing variables
@Carla_Marie_Barte Filter Datatable Will Just Filter the Datatable. It will not effect the Excel File
I think you need to use Filter Table instead of Filter Datatable if you want the Expected Output
dont do it