10-to-26-to-conversion (base for A-Z)-php Tutorial

10-to-26-to-A-Z conversion

10 hexadecimal to 26 hexadecimal (base for A-Z) conversion, the 10 hexadecimal number into a Z-A base for the 26 hexadecimal data. Used to obtain the index of a specified column in excel /** * Obtain the name index of a specified unit in an excel table: * For example, 1st rows and 1st columns: * A1 is returned. * Column 2 of row 27th: * AA1 returned: * * @ Param int $ row * @ Param int $ column of col * * @ Author mingche * @ Since 2014-05-31 */ Function getExcelCeilIndex ($ row, $ col ){ If ($ row> 0 & $ col> 0) { $ Str = "ZABCDEFGHIGKLMNOPQRSTUVWXY "; $ Col_str = ""; Do { $ Col_tmp = $ col % 26; $ Col = $ col_tmp = 0? Intval ($ col/26)-1: intval ($ col/26 ); $ Col_str = $ str [$ col_tmp]. $ col_str; } While ($ col ); Return $ col_str. $ row; } Return false; } ?>