Pulling the data out of Excel isn't too difficult (Win32::OLE), it's the parsing of the model file that's the problem. The model file, in its simplest form, is exactly what you say: a list of cells and what should be in them, in terms of strings, calculations, etc. I leverage Perl's regexes to grade things like graph axis titles - as you guessed, there's a hideous number of ways for them to write µmol min−1 mg−1, which makes me ache for the /x modifier. Using <perl_quotelike> seemed like an easy way out for both strings and regexes, but it looks increasingly like it'd be better to hand-roll something more limited.
in reply to Re: Using Parse::RecDescent to parse Perl-ish strings without resorting to string eval
in thread Using Parse::RecDescent to parse Perl-ish strings without resorting to string eval