def strindex_to_stdindex(strindex):
        '''converts from standard spreadsheet string index into stdindex'''
        # log = easy_log.getLogger(level = LOGGING_LEVEL)
        strindex = strindex.upper().replace(' ', '')
        
        # strindex will be, say 'AA100'.  Find the break point
        n = first_index_lt(strindex, 'A')
        row = int(strindex[n:]) - 1
        
        col_list = list(strindex[:n])
        col_list.reverse()
        col = 0
        for n, c in enumerate(col_list):
            col += (ord(c) - ord('A') + 1) * (26 ** n)
        col -= 1
        return row, col
converts from standard spreadsheet string index into stdindex
recipes/Python/578142_Working_with_Excel_Indexes/recipe-578142.py