Excel Custom XPath Function

The Excel Custom XPath function is designed to help users complete most functions of the ExcelData and the ExcelMetaData activities in a simplified way.

The following table describes the items in the Excel Custom XPath function.
Item Description
d_cloneSheetBySheetName Clones a sheet based on the sheet name.
d_cloneSheetBySheetPointer Clones a sheet based on the sheet pointer.
d_createSheets Creates sheets for an Excel file.
d_deleteRowsBySheetName Deletes rows based on the sheet name.
d_deleteRowsBySheetPointer Deletes rows based on the sheet pointer.
d_deleteSheetBySheetName Deletes a sheet based on the sheet name.
d_deleteSheetBySheetPointer Deletes a sheet based on the sheet pointer.
d_deleteSingleRowBySheetName Deletes a single row based on the sheet name.
d_deleteSingleRowBySheetPointer Deletes a single row based on the sheet pointer.
d_searchCellCommentBySheetName Searches a cell comment in an Excel sheet based on the sheet name.
d_searchCellCommentBySheetPointer Searches a cell comment in an Excel sheet based on the sheet pointer.
d_searchCellValueBySheetName Searches a cell value in an Excel sheet by the sheet name.
d_searchCellValueBySheetPointer Searches a cell value in an Excel sheet by the sheet pointer.
md_getAuthor Gets the author of an Excel file.
md_getCategories Gets the category of an Excel file.
md_getComments Gets the comments of an Excel file.
md_getCompany Gets the company of an Excel file.
md_getCreatedDate Gets the created date of an Excel file.
md_getLastModifiedBy Gets information about who last modified the Excel file.
md_getLastModifiedDate Gets the last modified date of an Excel file.
md_getManager Gets the manager of an Excel file.
md_getRevision Gets the revision number of an Excel file.
md_getStatus Gets the status of an Excel file.
md_getSubject Gets the subject of an Excel file.
md_getTags Gets the tags of an Excel file.
md_getTemplate Gets the template of an Excel file.
md_getTitle Gets the title of an Excel file.
md_setAuthor Sets the author for an Excel file.
md_setCategories Sets the category for an Excel file.
md_setComments Sets comments for an Excel file.
md_setCompany Sets the company for an Excel file.
md_setManager Sets the manager for an Excel file.
md_setRevision Sets the revision number for an Excel file.
md_setStatus Sets the status for an Excel file.
md_setSubject Sets the subject for an Excel file.
md_setTags Sets tags for an Excel file.
md_setTitle Sets the title for an Excel file.
Note: Items with initial d in the Excel Functions folder indicate corresponding functions in the ExcelData activity. Items with initial md in the Excel Functions folder indicate corresponding functions in the ExcelMetaData activity.