When working with excel and you need to know the column name given it's index for example column 0 is A, column 26 is AA
etc. Also given AA reverse the it to get a column index of 26. A little bit into what each function does, get_cell_value
takes in a string of a given excel cell e.g. A5 where A is the column name and 0 is the row index. It returns the row and
column index as [5, 0] i.e. an array/tuple where 5 is the row index and 0 is the column index. In short row 5 column 0. The
getColumnName
takes in the column index and reeturns the string version of it. For example getColumnName(5)
means get
the string equivalent of column with a column index of 5 which returns E.
<?php