Python excel_column_number Exemples

Exemple #1

Fichier : test_excel.py Projet : bossadvisors/xypath

 def test_excel_col(self):
     assert_equal(exceltool.excel_column_number("A"), 1)
     assert_equal(exceltool.excel_column_number("Z"), 26)
     assert_equal(exceltool.excel_column_number("Z")+1, exceltool.excel_column_number("AA"))
     assert_equal(exceltool.excel_column_number("AZ")+1, exceltool.excel_column_number("BA"))
     assert_equal(exceltool.excel_column_number("ZZ")+1, exceltool.excel_column_number("AAA"))
     assert_equal(exceltool.excel_column_number("CAZ")+1, exceltool.excel_column_number("CBA"))

Exemple #2

 def test_excel_col(self):
     assert_equal(exceltool.excel_column_number("A"), 1)
     assert_equal(exceltool.excel_column_number("Z"), 26)
     assert_equal(exceltool.excel_column_number("Z")+1, exceltool.excel_column_number("AA"))
     assert_equal(exceltool.excel_column_number("AZ")+1, exceltool.excel_column_number("BA"))
     assert_equal(exceltool.excel_column_number("ZZ")+1, exceltool.excel_column_number("AAA"))
     assert_equal(exceltool.excel_column_number("CAZ")+1, exceltool.excel_column_number("CBA"))

Exemple #3

 def col(self, column):
     if isinstance(column, six.string_types):
         c_num = contrib_excel.excel_column_number(column, index=0)
         return self.col(c_num)
     else:
         assert isinstance(column, int)
         return self._x_index[column]

Exemple #4

 def col(self, column):
     if isinstance(column, six.string_types):
         c_num = contrib_excel.excel_column_number(column, index=0)
         return self.col(c_num)
     else:
         assert isinstance(column, int)
         return self._x_index[column]