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

8 vues (au cours des 30 derniers jours)
Sweet Potato
Sweet Potato le 14 Fév 2018
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.

Réponses (1)

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

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by