MarkLogic Server 11.0 Product Documentationxdmp:excel-convert
xdmp:excel-convert( $doc as node(), $filename as xs:string, [$options as (element()|map:map)?] ) as node()*
Summary
Converts a Microsoft Excel document to XHTML. Returns several nodes, including a parts node, the converted document xml node, and any other document parts (for example, css files and images). The first node is the parts node, which contains a manifest of all of the parts generated as result of the conversion. Does not convert Microsoft Office 2007 and later documents.
| Parameters | |
|---|---|
| doc | Microsoft Office Excel document to convert to HTML, as binary node(). |
| filename | The root for the name of the converted files and directories. If the specified filename includes an extension, then the extension is appended to the root with an underscore. The directory for other parts of the conversion (images, for example) has the string "_parts" appended to the root. For example, if you specify a filename of "myFile.xls", the generated names will be "myFile_xls.xhtml" for the xml node and "myFile_xls_parts" for the directory containing the any other parts generated by the conversion (images, css files, and so on). |
| options |
Options with which to customize this operation.
You can specify options as either an XML
options element
in the "xdmp:excel-convert" namespace, or as a map:map. The
options names below are XML element localnames. When using a map,
replace any hyphens with camel casing. For example, "an-option"
becomes "anOption" when used as a map:map key.
This function supports the following options, plus the options from the
xdmp:tidy
function.
|
Usage Notes
This function is part of a separate package which may generate temporary files. These temporary files are not supported by encryption at rest.
This function is not available on Mac OS X.This function requires separate converter installation package starting with release 9.0-4, see MarkLogic Converters Installation Changes Starting at Release 9.0-4 in the Installation Guide for All Platforms.
This function supports the following file formats: Microsoft Excel 97/98 (Mac)/2000/2001 (Mac)/XP/2003.
The convert functions return several nodes. The first node is a manifest containing the various parts of the conversion. Typically there will be an xml part, a css part, and some image parts. Each part is returned as a separate node in the order shown in the manifest.
Therefore, given the following manifest:
<parts> <part>myFile_xls.xhtml</part> <part>myFile_xls_parts/conv.css</part> <part>myFile_xls_parts/toc.xml</part> </parts>
the first node of the returned query is the manifest, the second is the "myFile_xls.xhtml" node, the third is the "myFile_xls_parts/conv.css" node, and the fourth is the myFile_xls_parts/toc.xml node.
Example
let $results := xdmp:excel-convert(
xdmp:document-get("myFile.xls"),
"myFile.xls" ),
$manifest := $results[1]
return
$results[2 to last()]
(: Returns all of the converted nodes :)
Example
(: The following example includes a combination of xdmp:excel-convert
: options and xdmp:tidy options in the options element. :)
let $results := xdmp:excel-convert(
xdmp:document-get("myFile.xls"),
"myFile.xls",
<options xmlns="xdmp:excel-convert" xmlns:tidy="xdmp:tidy">
<tidy>true</tidy>
<tidy:clean>yes</tidy:clean>
<sheetID>2</sheetID>
</options>),
$manifest := $results[1]
return
$results[2 to last()]
(: Returns all of the converted nodes :)
Example
(: The following example includes a combination of xdmp:excel-convert
: options and xdmp:tidy options in the options map. :)
let $results := xdmp:excel-convert(
xdmp:document-get("myFile.xls"),
"myFile.xls",
map:map() => map:with("tidy", fn:true())
=> map:with("printAreaOnly", "yes")
=> map:with("sheetID", 2),
$manifest := $results[1]
return
$results[2 to last()]
(: Returns all of the converted nodes :)