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

14 次查看（过去 30 天）
Sweet Potato
Sweet Potato 2018-2-14
回答： Pruthvi G 2020-11-17
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.

请先登录，再回答此问题。

回答（1 个）

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

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by