search

mamullen13316 / ansible_xls_to_facts

Ansible module to convert Excel spreadsheet to facts
27 stars 16 forks source link

Using this on a cell w/ functions produces the formula #1

Closed netman2048 closed 7 years ago

netman2048 commented 7 years ago

I attempted to use this on a cell that is using a formula. The resulting variable is the function itself and not the output of the function. Any idea of how to resolve this?

netman2048 commented 7 years ago

I figured it out...I needed to go into your code and change the "load_workbook" parameters to:

wb = openpyxl.load_workbook(input_file, data_only=True)