forrest-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From iss...@cocoondev.org
Subject [JIRA] Updated: (FOR-373) Excel to Forrest: namespaces
Date Fri, 19 Nov 2004 15:12:50 GMT
The following issue has been updated:

    Updater: Johannes Schaefer (mailto:josch@uidesign.de)
       Date: Fri, 19 Nov 2004 9:10 AM
    Comment:
Extraction of simple tables from Excel.
Unzip and put into the appropriate places.

The Stylesheet creates one section and table per Excel tabsheet. The title of the page is
taken from the Excel properties, the subtitles are the sheet titles. In Excel use File->Save
as... and select File type XML. The file must be named *-table.xml.

The first line of a sheet is taken as table header. Empty cells are not displayed. Excel formatting
is ignored. If the first cell of a row is "figure" this will create a figure above the table
with the second cell as filename (appended to "image/") and the fourth (4th) cell as figure
caption (may be more than one figure). Images need to be copied to Forrest's images-folder.

The stylesheet is suboptimal: it makes (too much) use of XSL position(); I did not know better,
so I used XSL modes for table header and figure; all empty cells are removed: this may move
cells to the left, so in Excel you need to insert a space into empty cells.

I would be very glad if someone could improve on the stylesheet, so that I have a cance to
learn :-)

Johannes
    Changes:
             Attachment changed to table2forrest.zip
    ---------------------------------------------------------------------
For a full history of the issue, see:

  http://issues.cocoondev.org//browse/FOR-373?page=history

---------------------------------------------------------------------
View the issue:
  http://issues.cocoondev.org//browse/FOR-373

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: FOR-373
    Summary: Excel to Forrest: namespaces
       Type: Bug

     Status: Unassigned
   Priority: Major

    Project: Forrest
 Components: 
             Core operations
   Versions:
             0.7

   Assignee: 
   Reporter: Johannes Schaefer

    Created: Tue, 16 Nov 2004 8:11 AM
    Updated: Fri, 19 Nov 2004 9:10 AM
Environment: 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



---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira


Mime
View raw message