Esempi in Python per column_name_to_index

Esempio n. 1

def _asColumnReference(columnName, worksheetInfo):
    worksheetInfo.append(columnName)
    columnReference = FLColumnReference(worksheetInfo)
    if column_name_to_index(columnReference.plainColumnName):
        return columnReference

Esempio n. 2

File: fl_column_reference_parse_node.py Progetto: prio/dirigible-spreadsheet

 def colIndex(self):
     return column_name_to_index(self.plainColumnName)

Esempio n. 3

File: grammar.py Progetto: AlexanderAA/dirigible-spreadsheet

def _asColumnReference(columnName, worksheetInfo):
    worksheetInfo.append(columnName)
    columnReference = FLColumnReference(worksheetInfo)
    if column_name_to_index(columnReference.plainColumnName):
        return columnReference

Esempio n. 4

 def colIndex(self):
     return column_name_to_index(self.plainColumnName)

Esempio n. 5

File: test_cell_name_utils.py Progetto: AlexanderAA/dirigible-spreadsheet

    def testColumnNameTo(self):
        "test column_name_to_index"
        self.assertEquals(column_name_to_index("A"), 1, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("S"), 19, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("Z"), 26, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("AA"), 27, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("aa"), 27, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("AZ"), 52, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("aZ"), 52, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("BA"), 53, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("Ba"), 53, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("mjJ"), 9058, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("MJJ"), 9058, "incorrect conversion"  )
        self.assertEquals(column_name_to_index("ZZZ"), 18278, "incorrect conversion")

        self.assertIsNone(column_name_to_index("AAAA"), "invalid column not None")
        self.assertIsNone(column_name_to_index("HELLO3"), "invalid column not None")
        self.assertIsNone(column_name_to_index("SHEET"), "invalid column not None")
        self.assertIsNone(column_name_to_index("@"), "invalid column not None")
        self.assertIsNone(column_name_to_index("33"), "invalid column not None")
        self.assertIsNone(column_name_to_index("FXSHRXX"), "invalid column not None (column too large for 32 bit int)")