Name Manager name address format to JS API
We have given each Excel Table column our own Name using Name Manager. Now it is hard to find mapping between that and Table Column Name/Index. Excel UI shows it in Name Manager this way: =dimensionstable[[#Headers];[Dimension]] in 'Refers to' text box, but namedItemObject.getRange(); returns Range and from Range you get it out only in A1 format relative to worksheet, not in the form that Name Manager shows it, which would be needed.
We cannot use Table Header Names to identify column as user can change that (and we want to leave that option for user), so we use our own name for column to identify it, but it is hard to derive from that mapping to table column index.