Using extractFromExcel.xsl

<oXygen/> general issues.
pbw
Posts: 24
Joined: Sat Jul 12, 2008 3:46 am
Location: Brisbane, Australia

Using extractFromExcel.xsl

Post by pbw » Mon Dec 07, 2009 4:18 pm

The above stylesheet is in the samples for the 11.0 distribution. Is it possible to invoke it against an open xlsx file? If so, how?

iulian_velea
Posts: 63
Joined: Fri Dec 12, 2003 6:34 pm
Contact:

Re: Using extractFromExcel.xsl

Post by iulian_velea » Mon Dec 07, 2009 5:13 pm

Hi,

The xlsx documents should be open in the Archive view. In this view you can see the structure of folders and files that represent the xlsx document. The sheets that contain the actual data are located in the "worksheets" folder.
After opening one of this files you can configure a transformation that applies the "extractFromExcel.xsl" stylesheet and run it as on any other xml document.

Cheers,
Iulian.

Post Reply