1. Advisor
  2. pylightxl
  3. functions
  4. pylightxl.database.columnletter2num
View all pylightxl analysis

How to use the pylightxl.database.columnletter2num function in pylightxl

To help you get started, we’ve selected a few pylightxl examples, based on popular ways it is used in public projects.

Secure your code as it's written. Use Snyk Code to scan source code in minutes - no build needed - and fix issues immediately.

github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)
github PydPiper / pylightxl / test / test_readxl.py View on Github external
def test_col2num(self):
        self.assertEqual(columnletter2num('A'), 1)
        self.assertEqual(columnletter2num('Z'), 26)
        self.assertEqual(columnletter2num('AA'), 27)
        self.assertEqual(columnletter2num('BA'), 53)
        self.assertEqual(columnletter2num('YQ'), 667)
        self.assertEqual(columnletter2num('ZZ'), 702)
        self.assertEqual(columnletter2num('AAA'), 703)
        self.assertEqual(columnletter2num('PZD'), 11496)
        self.assertEqual(columnletter2num('QGK'), 11685)
        self.assertEqual(columnletter2num('XFD'), 16384)

pylightxl

A light weight excel read/writer for python27 and python3 with no dependencies

GitHub
MIT
Latest version published 1 year ago

Package Health Score

59 / 100
Full package analysis

Popular pylightxl functions

Similar packages