XSLT help for Excel module

28. Aug 2008, 23:22 CET | Link Nicklas Karlsson

Any XSLT wizards out there?

I noticed that I was repeating code when creating Excel documents from both xhtml documents and dataTable (based on component ID) so I thought that I could just apply a XSLT template to the dataTable component, transform it to the xhtml format, Render that one and rip out the Excel data from the converter component. Doable?

The source is the normal dataTable

  <h:dataTable value="..." var="..." otherAttrs>
    facets...
    <h:column>
      facets...
      <h:outputText/>
    </h:column> 
  </h:dataTable>

and the output is the Excel xhtml format

  <e:workbook>
    <e:worksheet value="..." var="...">
      facets...
      <e:column>
        facets...
        <e:cell/>
      </e:column>
    </e:worksheet> 
  </e:workbook>

(more on the format can be found in the 2.1 docs)

any pointers ot code you can help with that will save me hours prototying through info from w3schools.com? ;-)

(hope this topic is replyable, at least the checkbox says [x] Open topic, allow replies.