autoFilter.Filters.Item('F')提示TypeError:Cannot read properties of undefined (reading 'Item')

阅读次数 43

const filterRange = ActiveSheet.UsedRange filterRange.ShowAllData; // 获取自动筛选对象 const autoFilter = filterRange.AutoFilter
// 获取地市列的筛选对象
const filter2 = autoFilter.Filters.Item('F')
// 设置筛选类型为值筛选
filter2.Operator = Enum.XlAutoFilterOperator.xlFilterValues
// 设置筛选的值
filter2.Criteria1 = ['广州']
// 应用筛选
autoFilter.ApplyFilter()

4 Answers