KeyboardInterrupt/ansible_xlsx_inventory

hostname_col not used for grouping in sheet_to_inventory()

BenoitCattie opened this issue · 2 comments

Hello,

i think in the sheet_to_inventory(), the grouping is assuming that hostname is in column '0' :
groups['_meta']['hostvars'][row[0].value][var_name.value.lower().replace(' ', '_')] = row[idx].value

I think it should be

groups['_meta']['hostvars'][row[hostname_col].value][var_name.value.lower().replace(' ', '_')] = row[idx].value

Benoit

Sorry for the late reply, I will look into this, not right away, but eventually!
Thank you for letting me know.

Created PR to fix this #15