|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
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 /
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)