Get column number from column name

Question

Is there any method to get the column number from the column name?

I can only retrieve the column name, and I need the column number for getCellMeta.

Thanks

Can you give more context to your question? Why do you need to get a column number using the name? When and why do you need getCellMeta? — PostureOfLearning, Jul 17 '13 at 23:35
Because I could only retrieve the col name. I need getcellmeta for this: http://stackoverflow.com/questions/17721500/custom-renderer-function-not-working-in-handsontable-plugin — Cornwell, Jul 18 '13 at 11:24
Seems to me you are trying to reinvent the wheel a bit here. Handsontable already has some of the functionality you are after. Have a look at my answer to the post you referred to. — PostureOfLearning, Jul 22 '13 at 00:24

score 3 · Accepted Answer · edited Jan 29 '16 at 15:59

Made this function that solved my problem:

function GetColFromName(name)
{
    var n_cols  =   $editorTableContainer.handsontable('countCols');
    var i       =   1;     

    for (i=1; i<=n_cols; i++)
    {
        if (name.toLowerCase() == $editorTableContainer.handsontable('getColHeader', i).toLowerCase()) {
            return i;
        }
    }
    return -1; //return -1 if nothing can be found
}

score 3 · Answer 2 · answered Apr 07 '17 at 08:14

3

This is almost what I required but not quite as I needed the column prop. I couldn't find the answer anywhere so thought I would add this to the thread that helped me.

instead of using 'getColHeader' use 'colToProp'.

answered Apr 07 '17 at 08:14

chris601

53
8

score 2 · Answer 3 · edited Jan 30 '19 at 13:05

2

Use propToCol("Column Name"). This returns the column's index.

edited Jan 30 '19 at 13:05

Stephan Vierkant

9,674
8
61
97

answered Jan 30 '19 at 12:18

Boobal Ganesan

51
3

Get column number from column name

3 Answers3