| XQUERY/XSLT API DOCUMENTATION 4.2 |
All XQuery & XSLT Functions MarkLogic Built-In Functions Admin (xdmp:) AppServer (xdmp:) Classifier (cts:) Debug (dbg:) Document Conversion (xdmp:) Extension (xdmp:) Documents, Directories, Properties, and Locks Functions Extension Functions Function Values Functions HTTP Functions JSON Functions MarkLogic Server Functions Search Functions XML Functions XQuery Context Functions XSLT Functions map (map:) Math (math:) Profile (prof:) Search (cts:) cts:query Constructors Functions Geospatial Functions Geospatial Lexicon Functions Lexicon Functions Search Functions Search Clustering Functions Security (xdmp:) Server Monitoring (xdmp:) Spell (spell:) Update (xdmp:) XQuery Library Modules Admin Library (admin:) Actions Functions Appserver Functions Database Functions Forest Functions Group Functions Host Functions Mimetypes Functions Scheduler Functions Alerting (alert:) Elastic Compute Cloud (ec2:) Entity Enrichment (entity:) Flexible Replication (flexrep:) Geospatial Supporting Functions GEO Functions GeoRSS Functions GML Functions KML Functions MCGM Functions Information Studio (info:) Information Studio Developer (infodev:) Library Services (dls:) cts:query Constructor Functions Document Management Functions Document Update Functions Retention Policy Functions XInclude Functions Modular Documents XInclude Functions XPointer Functions PKI (pki:) Plugin (plugin:) Search (search:) Security-sec (sec:) Spelling Dictionary Management (spell:) Thesaurus (thsr:) Triggers (trgr:) Triggers Library (trgr:) WordProcessingML (ooxml:) ZIP Package (ooxml:) CPF Functions Content Processing Framework (cpf:) CSS Conversion (css:) DocBook Conversion (dbk:) Domains (dom:) Excel Conversion (excel:) Generic Conversion (cvt:) Links (lnk:) MSWord Conversion (msword:) PDF Conversion (pdf:) Pipelines (p:) Powerpoint Conversion (ppt:) XHTML Conversion (xhtml:) W3C-Standard Functions Accessor (fn:) AnyURI (fn:) Boolean (fn:) Context (fn:) DurationDateTime (fn:) Error and Trace (fn:) Node (fn:) Numeric (fn:) QName (fn:) Sequence (fn:) String (fn:) XSLT (fn:) W3C XQuery/XSLT Reference W3C XQuery Functions W3C XQuery Language W3C XSLT Language
This page was generated September 12, 2012 6:01 AM | XQuery & XSLT Built-In & Modules Function Reference
Module: Excel Conversion
The Excel module is part of the conversion processing pipeline. These functions are used to manipulate XHTML derived by converting Microsoft Excel spreadsheets, as part of conversion processing. To use the Excel module as part of your own XQuery module, include the following line in your XQuery prolog: `import module namespace excel = "http://marklogic.com/cpf/excel" at "/MarkLogic/conversion/excel.xqy";` You will need to ensure that the Excel module is loaded into the same modules database as the importing module. The library namespace prefix `excel` is not predefined in the server.
Function Summary
excel:clean | Clean up any conversion artifacts or other infelicities, putting each sheet into its own div element.
Function Detail
excel:clean(
| $uri as xs:string,
| $doc as node()?
) as node()?
Summary: Clean up any conversion artifacts or other infelicities, putting each sheet into its own div element.
Parameters:
$uri : The source URI of the converted spreadsheet.
$doc : The XHTML produced by conversion of a Microsoft Excel spreadsheet.
Example:
      xquery version "1.0-ml";
      import module namespace excel = "http://marklogic.com/cpf/excel"
    		  at "/MarkLogic/conversion/excel.xqy";

      excel:clean("my_xls.xhtml", fn:doc("my_xls.xhtml"))

© Copyright 2002-2012 MarkLogic Corporation. All rights reserved.