MATLAB Answers

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

18 views (last 30 days)
Sweet Potato
Sweet Potato on 14 Feb 2018
Answered: Pruthvi G on 17 Nov 2020
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.

Answers (1)

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

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!