Uploaded image for project: 'Forrest (Retired)'
  1. Forrest (Retired)
  2. FOR-373

Excel to Forrest stylesheets

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • 0.7
    • 0.7
    • None
    • tested with 0.6 and 0.7-55210

    Description

      I'm trying to get some tables out of Excel into
      Forrest ... should be easy since Excel writes
      legible XML [1].

      I put together a sitemap.xmap [2] for *-table.xml.

      I started writing my table2document.xsl [3] but
      it didn't match anything, i.e. the version below
      doesn't match anything. Matching "/*/*" gives me
      the 2nd level elements: DocumentProperties, ...,
      and Worksheets.

      After removing all references to namespaces (xmlns)
      and replacing ":" with "_" it works.

      Can any XSL guru help me to get the XSLT working
      without modifying the Excel-output first?

      Thanks,
      Johannes

      See Attachments
      [1] Excel XML output: test2-table.xml
      [2] documents/sitemap.xmap
      [3] table2document.xsl

      Attachments

        1. ASF.LICENSE.NOT.GRANTED--test2-table.xml
          4 kB
          Johannes Schäfer
        2. ASF.LICENSE.NOT.GRANTED--test2-table.xls
          14 kB
          Johannes Schäfer
        3. ASF.LICENSE.NOT.GRANTED--test.png
          12 kB
          Johannes Schäfer
        4. ASF.LICENSE.NOT.GRANTED--table2forrest.zip
          5 kB
          Johannes Schäfer
        5. ASF.LICENSE.NOT.GRANTED--table2document.xsl
          0.6 kB
          Johannes Schäfer
        6. ASF.LICENSE.NOT.GRANTED--table2document.xsl
          0.7 kB
          Johannes Schäfer
        7. ASF.LICENSE.NOT.GRANTED--table2document.xsl
          1 kB
          Johannes Schäfer
        8. ASF.LICENSE.NOT.GRANTED--sitemap.xmap
          0.4 kB
          Johannes Schäfer
        9. ASF.LICENSE.NOT.GRANTED--shop.jpg
          24 kB
          Johannes Schäfer
        10. ASF.LICENSE.NOT.GRANTED--org.apache.forrest.plugin.excel-table.zip
          506 kB
          Johannes Schäfer

        Activity

          People

            rgardler Ross Gardler
            josch Johannes Schäfer
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: