MarkLogic Server
XQUERY/XSLT API DOCUMENTATION
4.2
All XQuery & XSLT Functions
MarkLogic Built-In Functions
XQuery Library Modules
CPF Functions
W3C-Standard Functions
  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.