RE: [Templates] tt and SpreadSheet::WriteExcel

[Thomas, Mark - BLS CTR]

Title: Message

But again I havent thought this all the way through... but something like [% USE sheet = spreadsheet( filetype ) %] [% FOREACH row IN rows %] [% sheet.start_row() %] [% FOREACH cell IN row.cells %] [% sheet.add_cell( cell.data ) %] [% END %] [% sheet.end_row() %] [% END %] then you either add formatting via say an additional flag to add_cell    If you do that, you'd have to expose much of the Spreadsheet::WriteExcel API as a TT plugin due to the convoluted way SSWE and the underlying Excel binary representation work. Not only would that be difficult, but it wouldn't buy you anything. You'd be doing coding in TT instead of coding in perl. Perhaps that's your goal? I guess I'm back to the question I started with--why?   A TT version of the SSWE API is going to be just as hostile to non-programmers. Unless you build an abstraction layer like Spreadsheet::WriteExcel::Simple, but currently that just handles bold/non-bold row writing, not fonts, colors, widths, cell formats, etc.   - Mark.