How can I add a specific autofilter on a column in the excel file

Hello everyone,

I am trying to apply filter on a specific column in the excel sheet using Matlab.

For example, I have a 10x10 table, with column J contain 2 values: "true or false", I want to filter column J so that it only shows all the rows that contain 'true' value on column J. I recorded a macro on excel, and this was VBA code that I got, but I haven't found a way to make it works in Matlab.

ActiveSheet.Range("$A$1:$J$10").AutoFilter Field:=10, Criteria1:="True"

Thank you for all your help.

Answer 1

[Pruthvi G]

ActiveSheet.Range('10:10').AutoFilter

invoke(ActiveSheet.Range('A1:J10'), 'AutoFilter', 10,... %Field
      {'True'},... %Criteria1
      7); %operator = xlFilterValues