def test_xl_cell_to_rowcol_abs(self):

        tests = [
            # row, col, row_abs, col_abs, A1 string
            (0, 0, 0, 0, 'A1'),
            (0, 0, 1, 0, 'A$1'),
            (0, 0, 0, 1, '$A1'),
            (0, 0, 1, 1, '$A$1'),
        ]

        for row, col, row_abs, col_abs, string in tests:
            exp = (row, col)
            got = xl_cell_to_rowcol(string)
            self.assertEqual(got, exp)
Test xl_cell_to_rowcol() with absolute references
dataset/ETHPy150Open jmcnamara/XlsxWriter/xlsxwriter/test/utility/test_xl_cell_to_rowcol.py/TestUtility.test_xl_cell_to_rowcol_abs