OXMLWorksheet_RU Class [AX 2012]
The OXMLWorksheet_RU class is a wrapper around the Open XML SDK worksheet object.
| Method | Description | |
|---|---|---|
| addMergeCellsCopy | Adds merged cells to a worksheet when a range of rows is being copied. |
| addMergeCellsCopyTemplate | Adds merged cells that are contained within rows when you are working in template mode. |
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| colBreaks | Returns a set that contains data about existing column breaks. |
| cols | Returns a map that contains data about column parameters. |
| columnWidth | Returns the width of the specified row in units. |
| columnWidthPixels | Returns width of the specified column in pixels. |
| copyRowsTemplate | Copies rows when you are working in template mode. |
| deletePageBreak | Deletes a page break. |
| deleteRow | Deletes a row from the worksheet. |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| getCopyMergeCells | Creates a set that contains data about merged cells inside the rows that are being copied. |
| getDefaultHeight | Returns the default row height for this worksheet. |
| getDefaultStyleIndex | Returns the default style index. |
| getDefaultWidth | Returns the default column width for this worksheet |
| getMergeCellByTopLeft | Finds parameters for a merged cell based on the merged cell’s top-left coordinates. |
| getPageHeight | Gets the page height, excluding margins. |
| getPaperSize | Returns the paper size in inches. |
| getRowHeight | Gets the height of the specified row. |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| id | Returns the ID of this worksheet. |
| initColBreaksSet | Initializes a set that holds data about the column breaks in the worksheet. |
| initCols | Initializes a map that holds data about columns. |
| initMergeCells | Initializes a set that holds data about merged cells. |
| initRowBreaksSet | Initializes a set that holds data about the row breaks in the worksheet. |
| initRows | Initializes a map that hold data about the rows of this document. |
| initWorksheetElements | Initializes the XML elements of the worksheet from the template. |
| insertColBreak | Inserts a vertical (column) break into the worksheet. |
| insertOXMLRow | Adds a row to the document by using an OXMLRow_RU object. |
| insertPageBreak | Adds a page break. |
| insertRow | Copies a single row within the current worksheet. |
| mergeCells | Returns a set that holds data about the merged cells in the initial document. |
| name | Gets or sets the name of the worksheet. |
| new | Creates a new instance of the OXMLWorksheet_RU class. |
| notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) |
| notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) |
| objectOnServer | Determines whether the object is on a server. (Inherited from Object.) |
| owner | Returns the instance that owns the object. (Inherited from Object.) |
| parmSaveColumnWidths | Gets or sets the SaveColumnWidths parameter. |
| row | Returns the OXMLRow_RU object that corresponds to the row at the specified index. |
| rowBreaks | Returns a set that holds data about the horizontal page breaks in this document. |
| rows | Returns a map that holds data about rows. |
| rowsTemplate | Returns a map that holds data about the rows in the template. |
| rowTemplate | Gets the row at the specified index from the template. |
| save | Saves the data from maps (rows, merged cells, columns, breaks, and so on) to the document. |
| saveBreaks | Saves breaks (both vertical and horizontal) that are contained in the worksheet. |
| saveColumnWidths | Saves the column widths for the document. |
| saveMergeCells | Saves data about merged cells to the document. |
| saveRows | Saves data in the rows map to the document. |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| setWorksheetSpans | Sets the value of the current worksheet’s spans property, which sets the number of columns that are used. |
| sheetData | Is the method accessor for the Open XML SDK SheetData (rows) object. |
| shiftNamedCells | Shifts named cells after rows are added or removed. |
| toString | Returns a string that represents the current object. (Inherited from Object.) |
| usageCount | Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.) |
| wait | Pauses a process. (Inherited from Object.) |
| workbook | Is the method accessor for the OXMLWorkbook_RU object that contains the current worksheet. |
| worksheetId | Gets or sets the worksheet ID for this worksheet. |
| worksheetPart | Is the method accessor for the Open XML SDK worksheetPart object. |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
| ::newFromSheet | Creates a new instance of the OXMLWorksheet_RU class. |
Community Additions
ADD
Show: