SysExcelWorksheetHelper Class [AX 2012]
The SysExcelWorksheetHelper class helps create Microsoft Excel worksheets.
| Method | Description | |
|---|---|---|
| addColumn | Adds a column to the spreadsheet in the standard format and alignment for the specified column type. |
| addColumnFromTableField | Adds a column to the spreadsheet in the standard format and alignment for the specified table field. |
| alignRangeCenter | Aligns the specified worksheet range to the center. |
| alignRangeLeft | Aligns the specified worksheet range to the left. |
| alignRangeRight | Aligns the specified worksheet range to the right. |
| autoFitColumns | Resizes each columns of the worksheet to fit that largest value in that column. |
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| convertToString | Converts the provided value to a string. |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| formatWorksheetTableStyle | Formats the worksheet to use the standard table style. |
| getMonetaryNumberFormat | Retrieves the number format that is used to display monetary values. |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| getWorksheet | Retrieves the instance of the worksheet managed by this class. |
| getWorksheetRange | Retrieves an instance of the SysExcelRange class based on the provided range. |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| new | Creates an instance of the SysExcelWorksheetHelper 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.) |
| setCellValue | Sets the value of the cell provided. |
| setColumnAlignment | Aligns the specified column that is based on the type. |
| setColumnFormatting | Formats the specified column that is based on the type. |
| setFontBold | Changes the bold property of the specified worksheet range to true. |
| setFontColor | Changes the font color of the worksheet range provided. |
| setInteriorColor | Changes the interior color of the specified worksheet range. |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| sumRange | Sums the worksheet range provided and puts the result in the specified cell. |
| 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.) |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
| ::address | |
| ::construct | Initializes a new instance of the SysExcelWorksheetHelper class. |
Community Additions
ADD
Show: