def test_auto_filter(self): ws = Worksheet(self.wb) ws.auto_filter = ws.range('a1:f1') assert ws.auto_filter == 'A1:F1' ws.auto_filter = '' assert ws.auto_filter is None ws.auto_filter = 'c1:g9' assert ws.auto_filter == 'C1:G9'
def setup_auto_filter(worksheet: Worksheet, headers: List[str]) -> None: """Setup worksheet auto filter for those headers :param worksheet: :param headers: """ worksheet.auto_filter = AutoFilter( ref='A1:{}1'.format(chr(ord('A') + len(headers) - 1)))