First and foremost, thanks to everybody for you comments!

I believe a little clarification regarding the "binary" format would be of use. My idea was to be able to have a binary excel template, read it using Spreadsheet::ParseExcel and feed text and variables to TT for processing and then Spreadsheet::WriteExcel to a new binary file. My idea was to plugin where TT reads and writes a text file and convert "read next line" to "read next row" and "write line" to "write row".

Although the idea of marking and escaping the binary file directly seems like a nice candidate for the Obfuscation forum... my idea is to have a template that resembles the processed file for ease of template creation.

My final solution will be to convert Excel to text including a little markup that identifies columns ends and rows ends. Since a way to have markup "outside" rows and columns will arise I will use TT markup in comments that will be converted to text putting it "before" the column marker. Then run TT on it and read through the text converting the original marks to "next column" and "next row"

Thanks again to everybody.

In reply to Re: Binary Excel Templates by gbarco
in thread Binary Excel Templates by gbarco

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.