parsing an Excel formula with the re module

Chris Withers chris at simplistix.co.uk
Wed Jan 13 04:44:26 EST 2010


John Machin wrote:
> The OP was planning to dig the formula text out using COM then parse the 
> formula text looking for cell references and appeared to have a rather 
> simplistic view of the ease of parsing Excel formula text -- that's why 
> I pointed him at those facilities (existing, released, proven in the 
> field) in xlwt.

Which bits of xlwt are you referring to? (at a guess, the stuff that 
turns a piece of text into the correct formulae gubbinz when you write a 
formula to a cell with xlwt?)

cheers,

Chris

-- 
Simplistix - Content Management, Batch Processing & Python Consulting
            - http://www.simplistix.co.uk



More information about the Python-list mailing list