Page 1 of 1

Using extractFromExcel.xsl

Posted: Mon Dec 07, 2009 4:18 pm
by pbw
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?

Re: Using extractFromExcel.xsl

Posted: Mon Dec 07, 2009 5:13 pm
by iulian_velea
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.