PCExcel Class [AX 2012]

Implements a wrapper for Excel to be used for configuration purposes.

class PCExcel

Run On

Called

  MethodDescription
Dn541664.pubmethod(en-us,AX.60).gif addBoldCellValue Adds value to the cell with the Bold font.
Dn541664.pubmethod(en-us,AX.60).gif addCellValue Adds value to the cell.
Dn541664.pubmethod(en-us,AX.60).gif addComponent Adds component definition row to the document.
Dn541664.pubmethod(en-us,AX.60).gif addLeafNode Adds a leaf node of the product configuration price model to the spreadsheet.
Dn541664.protmethod(en-us,AX.60).gif bringExcelToForeground Brings Excel to the foreground
Dn541664.pubmethod(en-us,AX.60).gif buildHeader Builds sales price breakdown report header
Dn541664.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif createStyles Create default Excel styles for sales price breakdown report.
Dn541664.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif getTempFilePath Gets a temporary file path to store sales price breakdown document.
Dn541664.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif init Initialize Excel worksheet.
Dn541664.pubmethod(en-us,AX.60).gif initApplication Initialize SysExcelApplication class.
Dn541664.protmethod(en-us,AX.60).gif new Initializes a new instance of the PCExcel class.
Dn541664.pubmethod(en-us,AX.60).gif newRow Add new row to worksheet.
Dn541664.pubmethod(en-us,AX.60).gif notify Releases the hold on an object that has called the wait method on this object. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif notifyAll Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif open Opens the sales price breakdown report in Excel and brings Excel to the foreground.
Dn541664.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif parmApplication Gets or sets the Application parameter.
Dn541664.pubmethod(en-us,AX.60).gif parmHeaderStyle Gets or sets the HeaderStyle parameter.
Dn541664.pubmethod(en-us,AX.60).gif parmLineStyle Gets or sets the LineStyle parameter.
Dn541664.pubmethod(en-us,AX.60).gif populateCellValueInt Adds value to the cell.
Dn541664.pubmethod(en-us,AX.60).gif populateCellValueReal Adds value to the cell.
Dn541664.protmethod(en-us,AX.60).gif populateCellValuStr Populates value to the cell with the Bold font.
Dn541664.pubmethod(en-us,AX.60).gif save Saves the sales price breakdown.
Dn541664.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif usageCount Returns the current number of references, that is, the value of the reference counter, that the object has. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif useColorStyle Uses a line style color.
Dn541664.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif xml Returns an XML string that represents the current object. (Inherited from Object.)
Dn541664.pubmethod(en-us,AX.60).gif Dn541664.static(en-us,AX.60).gif ::construct Initializes a new instance of the PCExcel class.
Top

Community Additions

ADD
Show: