PCExcel Class [AX 2012]
Implements a wrapper for Excel to be used for configuration purposes.
| Method | Description | |
|---|---|---|
| addBoldCellValue | Adds value to the cell with the Bold font. |
| addCellValue | Adds value to the cell. |
| addComponent | Adds component definition row to the document. |
| addLeafNode | Adds a leaf node of the product configuration price model to the spreadsheet. |
| bringExcelToForeground | Brings Excel to the foreground |
| buildHeader | Builds sales price breakdown report header |
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| createStyles | Create default Excel styles for sales price breakdown report. |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| getTempFilePath | Gets a temporary file path to store sales price breakdown document. |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| init | Initialize Excel worksheet. |
| initApplication | Initialize SysExcelApplication class. |
| new | Initializes a new instance of the PCExcel class. |
| newRow | Add new row to worksheet. |
| 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.) |
| open | Opens the sales price breakdown report in Excel and brings Excel to the foreground. |
| owner | Returns the instance that owns the object. (Inherited from Object.) |
| parmApplication | Gets or sets the Application parameter. |
| parmHeaderStyle | Gets or sets the HeaderStyle parameter. |
| parmLineStyle | Gets or sets the LineStyle parameter. |
| populateCellValueInt | Adds value to the cell. |
| populateCellValueReal | Adds value to the cell. |
| populateCellValuStr | Populates value to the cell with the Bold font. |
| save | Saves the sales price breakdown. |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| 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.) |
| useColorStyle | Uses a line style color. |
| wait | Pauses a process. (Inherited from Object.) |
| xml | Returns an XML string that represents the current object. (Inherited from Object.) |
| ::construct | Initializes a new instance of the PCExcel class. |
Community Additions
ADD
Show: