Python Worksheet.auto_filterの例

コード例 #1

ファイル: test_worksheet.py プロジェクト: demula/pintracker

    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'

コード例 #2

    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'

コード例 #3

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)))