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: 
   my $oBook = new Spreadsheet::ParseExcel->new()->Parse('file.xml');
   my $template = Excel::Template->new($oBook);

   # or

   my $xml = Spreadsheet::ParseExcel->new()->Parse('file.xml')->toXML(
+);
   my $template = Excel::Template->new($xml);

[download]
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 reply to Re: Re: Modifying an Excel doc (UNIX) by dpmott
in thread Modifying an Excel doc (UNIX) by dpmott

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.