Ejemplos de excel_column_number en Python

Ejemplo n.º 1

Archivo: test_excel.py Proyecto: 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"))

Ejemplo n.º 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"))

Ejemplo n.º 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]

Ejemplo n.º 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]