Class MLA

Object
   |
   +--MLA

class MLA

Defined in MarkLogicExcelAddin.js


Nested Class Summary
<static class> MLA.Cell
 
Constructor Summary
MLA()
            The MLA namespace is used for global attribution.
 
Method Summary
<static> Object addAutoFilter(coord1, coord2, criteria1, operator, criteria2)
           Adds AutoFilter to specified range in active worksheet.
<static> String addCustomXMLPart(customPartXml)
           Adds custom part to active Open XML package.
<static> Object addNamedRange(coord1,coord2,rngName)
           Names a range in the active worksheet
<static> String addWorkbook(worksheetname)
           Adds workbook of type Excel.XlWBATemplate.xlWBATWorksheet.
<static> Object addWorksheet(name)
           Adds worksheet to active workbook.
<static> Object clearNamedRange(name)
           Clears all cells in the range identified by name
<static> Object clearRange(coord1,coord2)
           Clears all cells in the range identified by coordinates provide in A1 notation
<static> Object clearWorksheet()
           Clears the contents of the active worksheet in the active workbook
<static> Object convertA1ToR1C1(coord)
           Converts an A1 notation coordinate to R1C1 notations
<static> Object convertR1C1ToA1(rowIdx, colIdx)
           Converts a row index and column index to an A1 notation coordinate
<static> Object createXMLDOM(xmlstring)
           Utility function for creating Microsoft.XMLDOM object from string.
<static> void deleteCustomXMLPart(customXMLPartId)
           Deletes custom part from Active Open XML package identified by id.
<static> Object getActiveCell()
           Returns active cell from the active worksheet in active workbook.
<static> String getActiveCellText()
           Get the Text for the cell at the current cursor position.
<static> String getActiveWorkbookName()
           Returns the name of the active workbook.
<static> Array getActiveWorkbookWorksheetNames()
           Returns the names of all worksheets for active workbook as array of strings.
<static> String getActiveWorksheetName()
           Returns the name of the active worksheet.
<static> Array getAllWorkbookNames()
           Returns the names of all workbooks available as array of strings.
<static> Object getConfiguration()
           Returns MLA.config.
<static> Microsoft.XMLDOM object getCustomXMLPart(customXMLPartId)
           Returns the custom XML part, identified by customXMLPartId, that is part of the active Open XML package.
<static> Array getCustomXMLPartIds()
           Returns ids for custom parts (not built-in) that are part of the active Open XML package.
<static> Object getNamedRangeNames()
           Returns all NamedRange names for the active workbook
<static> Object getSelectedCells()
           Returns cells selected in active workbook.
<static> Object getSelectedRangeCoordinates()
           Returns the selected range coordinates.
<static> Object getTempPath()
           Returns the path being used for the /temp dir on the client system
<static> String getVersion()
           Returns version of MarkLogicExcelAddin.js library.
<static> Object openXlsx(tmpPath, docuri, url, uname, pwd)
           Open a .xlsx from MarkLogic into Excel
<static> Object removeNamedRange(name)
           Removes the NamedRange from the active workbook.
<static> Object saveActiveWorkbook(tmpPath, doctitle, url, uname,pwd)
           Saves the active workbook to MarkLogic
<static> Object setActiveCellValue(value)
           Set the value for the cell at the current cursor position.
<static> Object setActiveRangeByName(name)
           Returns all NamedRange names for the active workbook
<static> Object setActiveWorkbook(workbookname)
           Sets the active workbook in Excel.
<static> Object setActiveWorksheet(sheetname)
           Sets the active worksheet in Excel.
<static> Object setCellValue(cells, sheetname)
           Sets the values for the cells identified by Cell.coordinate

Constructor Detail

MLA

MLA()

Method Detail

addAutoFilter

<static> Object addAutoFilter(coord1, coord2, criteria1, operator, criteria2)

addCustomXMLPart

<static> String addCustomXMLPart(customPartXml)

addNamedRange

<static> Object addNamedRange(coord1,coord2,rngName)

addWorkbook

<static> String addWorkbook(worksheetname)

addWorksheet

<static> Object addWorksheet(name)

clearNamedRange

<static> Object clearNamedRange(name)

clearRange

<static> Object clearRange(coord1,coord2)

clearWorksheet

<static> Object clearWorksheet()

convertA1ToR1C1

<static> Object convertA1ToR1C1(coord)

convertR1C1ToA1

<static> Object convertR1C1ToA1(rowIdx, colIdx)

createXMLDOM

<static> Object createXMLDOM(xmlstring)

deleteCustomXMLPart

<static> void deleteCustomXMLPart(customXMLPartId)

getActiveCell

<static> Object getActiveCell()

getActiveCellText

<static> String getActiveCellText()

getActiveWorkbookName

<static> String getActiveWorkbookName()

getActiveWorkbookWorksheetNames

<static> Array getActiveWorkbookWorksheetNames()

getActiveWorksheetName

<static> String getActiveWorksheetName()

getAllWorkbookNames

<static> Array getAllWorkbookNames()

getConfiguration

<static> Object getConfiguration()

getCustomXMLPart

<static> Microsoft.XMLDOM object getCustomXMLPart(customXMLPartId)

getCustomXMLPartIds

<static> Array getCustomXMLPartIds()

getNamedRangeNames

<static> Object getNamedRangeNames()

getSelectedCells

<static> Object getSelectedCells()

getSelectedRangeCoordinates

<static> Object getSelectedRangeCoordinates()

getTempPath

<static> Object getTempPath()

getVersion

<static> String getVersion()

openXlsx

<static> Object openXlsx(tmpPath, docuri, url, uname, pwd)

removeNamedRange

<static> Object removeNamedRange(name)

saveActiveWorkbook

<static> Object saveActiveWorkbook(tmpPath, doctitle, url, uname,pwd)

setActiveCellValue

<static> Object setActiveCellValue(value)

setActiveRangeByName

<static> Object setActiveRangeByName(name)

setActiveWorkbook

<static> Object setActiveWorkbook(workbookname)

setActiveWorksheet

<static> Object setActiveWorksheet(sheetname)

setCellValue

<static> Object setCellValue(cells, sheetname)


Documentation generated by JSDoc on Wed Apr 8 14:29:46 2009