inserting a formula into a range of cells | jhc | 11/10/10 3:55 PM | I'd like to insert a formula into a range of cells. So if I was just
in Excel I would type the formula in, then 'copy down' in the remaining cells. Is there a way to do this in Python? I'm just a newbie - I didn't even know any of this was possible before this week. So please give me an example that I can use. I was hoping something along the lines of cell A2 = B2 / myVariableOrConstant thanks in advance |

Re: [pyxl] inserting a formula into a range of cells | John Machin | 11/10/10 5:45 PM | Inserting cells into an existing workbook, or into a workbook on the fly In the latter case, you need know only about xlwt (which creates XLS See the tutorial that you can access via http://www.python-excel.org. The formula examples in the tutorial don't cover the "copy down" [preliminaries omitted; rows and columns are enumerated starting from sheet.write(1, 1, Formula('A2'), a_style) Cheers, |