Welcome to the Monastery | |
PerlMonks |
Re: Re: Modifying an Excel doc (UNIX)by dpmott (Scribe) |
on Dec 05, 2003 at 04:37 UTC ( [id://312425]=note: print w/replies, xml ) | Need Help?? |
We have things in the workbook like those popup controls, and VBA macros that pull data out of the other worksheet to populate those controls.
Between the controls and the VBA macros, and also the desire to lay out the look+feel of the first spreadsheet (it's basically an end-user form), it seems like a path fraught with perils and hardship to generate the whole thing with Excel::Template or Spreadsheet::WriteExcel. Unless I'm missing something? I didn't see a way that the two modules natively worked together? i.e. didn't see: Actually, I didn't even see a way to directly supply a string for Excel::Template to parse. Would I have to make one of those nifty string-backed in-memory files to make that work? Nor did I see that Excel::Template would read+parse an Excel file and give you the XML that you could then twiddle into a desired template. If I missed something obvious there, let me know. I appreciate your offer to add features... off the top of my head (and unless I missed them), I'd suggest a parse_string() method, and an interface to supply a workbook from Spreadsheet::ParseExcel (which would generate an XML representation of that workbook). That last one sounds painful, though... might be better to have Spreadsheet::ParseExcel attempt to render the XML for you? -Dave
In Section
Seekers of Perl Wisdom
|
|