[TriZPUG] xlwt and Data / Subtotals?

[Josh Johnson]

Have you tried just writing the formula into the cell, as you would in  
excel? I've not used xlwt, but recall having some success with that in  
the past.

I'd also be grepping the _source code_ and the examples for "formula"  
if I were you :) IIRC, the excel function is SUM(), and you can pass  
it a cell range, eg =SUM(A1:A5)

HTH,
JJ

On Nov 2, 2009, at 4:44 PM, Paul Godley wrote:

> Greetings All,
>
> I use xlwt to create some Excel worksheets from data in Postgres. I've
> not had a need to use formula before, but now I'm interested in
> implementing the behavior you get in Excel when you use the Data /
> Subtotals... menu. My Google efforts haven't turned up anything
> useful. A grep of the xlwt "examples" folder for "subtotal" returns no
> hits. Does anyone know if xlwt supports this kind of thing? I've seen
> subtotals mentioned in ExcelMagic.py, but I don't understand it yet.
>
> If you know it can or cannot be done, that'll put me on the right  
> path.
>
> Thanks!
>
> -P
> _______________________________________________
> TriZPUG mailing list
> TriZPUG at python.org
> http://mail.python.org/mailman/listinfo/trizpug
> http://trizpug.org is the Triangle Zope and Python Users Group
>