If it helps, I started a similar project a few years ago on SourceForge when I
was just learning python called python2xlw. I haven't supported it for quite
a while, however, I still use it a lot in my own work.
I needed to create Excel files with scatter charts in them for a web interface
so
I find that I use lambda functions mainly for callbacks to things like
integration or root finding routines as follows.
flow = integrate(lambda x: 2.0*pi * d(x)* v(x) * sin(a(x)),xBeg, xEnd)
root = findRoot(xBeg, xEnd,
lambda x: y2+ lp*(x-x2) -wallFunc( x )[0], tolerance=1.0E-15)
I hav