Copy Excel Fromul in Python

Question

I have a large spreadsheet that I am processing in python. The source sheet has embeded excel formulas. I am using the libraries xlrd and xlwt. The formatting (such as hightlight) is copied from the source data, however formulas are not copied. How can this be resolved?

Code to copy the sheet;

 def copy2(wb):
        w = XLWTWriter()
        process(XLRDReader(wb, 'unknown.xls'), w)
        return w.output[0][1], w.style_list

possible duplicate of [Get formula from Excel cell with python xlrd](http://stackoverflow.com/questions/4690423/get-formula-from-excel-cell-with-python-xlrd) — Andy, Mar 27 '15 at 13:25

score 0 · Answer 1 · answered Mar 27 '15 at 18:45

It is not possible to do this with xlrt, xlwt. I have solved this by using the library xlwings. xlwings will add columns to already existing sheets without needing to copy the data to write to it. This will allow you to use python to add columns to already existing workbooks with formulas / vba / formatting.

Copy Excel Fromul in Python

1 Answers1