Python - xlwt formula parsing -

Python - xlwt formula parsing -

i'm using combination of xlrd, xlutils.copy , xlwt re-create existing .xls workbook (including formulae) , have found that, while xlwt's formula parsing handles functions index() in them, resultant workbook populated #value wherever appear. these can removed manually f2 nail homecoming in excel wanted more automated solution.

one prepare found fluke appears to go xlwt\excelmagic.py , change:

'index' : ( 29, 2, 4, 'r', 'rvvv'),

to

'index' : ( 29, 2, 4, 'v', 'rvvv'),

'r' , 'v', i'm guessing stand reference , value, described "func homecoming type". mean , alter i've made break anything?

thanks

python xlwt