SysExcelWorksheetHelper Class [AX 2012]

The SysExcelWorksheetHelper class helps create Microsoft Excel worksheets.

class SysExcelWorksheetHelper

Run On

Client

  MethodDescription
Gg959382.pubmethod(en-us,AX.60).gif addColumn Adds a column to the spreadsheet in the standard format and alignment for the specified column type.
Gg959382.pubmethod(en-us,AX.60).gif addColumnFromTableField Adds a column to the spreadsheet in the standard format and alignment for the specified table field.
Gg959382.pubmethod(en-us,AX.60).gif alignRangeCenter Aligns the specified worksheet range to the center.
Gg959382.pubmethod(en-us,AX.60).gif alignRangeLeft Aligns the specified worksheet range to the left.
Gg959382.pubmethod(en-us,AX.60).gif alignRangeRight Aligns the specified worksheet range to the right.
Gg959382.pubmethod(en-us,AX.60).gif autoFitColumns Resizes each columns of the worksheet to fit that largest value in that column.
Gg959382.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg959382.protmethod(en-us,AX.60).gif convertToString Converts the provided value to a string.
Gg959382.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from Object.)
Gg959382.pubmethod(en-us,AX.60).gif formatWorksheetTableStyle Formats the worksheet to use the standard table style.
Gg959382.pubmethod(en-us,AX.60).gif getMonetaryNumberFormat Retrieves the number format that is used to display monetary values.
Gg959382.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg959382.pubmethod(en-us,AX.60).gif getWorksheet Retrieves the instance of the worksheet managed by this class.
Gg959382.pubmethod(en-us,AX.60).gif getWorksheetRange Retrieves an instance of the SysExcelRange class based on the provided range.
Gg959382.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg959382.protmethod(en-us,AX.60).gif new Creates an instance of the SysExcelWorksheetHelper class.
Gg959382.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.)
Gg959382.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.)
Gg959382.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg959382.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg959382.pubmethod(en-us,AX.60).gif setCellValue Sets the value of the cell provided.
Gg959382.protmethod(en-us,AX.60).gif setColumnAlignment Aligns the specified column that is based on the type.
Gg959382.protmethod(en-us,AX.60).gif setColumnFormatting Formats the specified column that is based on the type.
Gg959382.pubmethod(en-us,AX.60).gif setFontBold Changes the bold property of the specified worksheet range to true.
Gg959382.pubmethod(en-us,AX.60).gif setFontColor Changes the font color of the worksheet range provided.
Gg959382.pubmethod(en-us,AX.60).gif setInteriorColor Changes the interior color of the specified worksheet range.
Gg959382.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg959382.pubmethod(en-us,AX.60).gif sumRange Sums the worksheet range provided and puts the result in the specified cell.
Gg959382.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg959382.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.)
Gg959382.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg959382.pubmethod(en-us,AX.60).gif xml Returns an XML string that represents the current object. (Inherited from Object.)
Gg959382.privmethod(en-us,AX.60).gif Gg959382.static(en-us,AX.60).gif ::address
Gg959382.pubmethod(en-us,AX.60).gif Gg959382.static(en-us,AX.60).gif ::construct Initializes a new instance of the SysExcelWorksheetHelper class.
Top

Use the SysExcelHelper class to create manage creating the overall workbook.

Object Class
  SysExcelWorksheetHelper Class

Community Additions

ADD
Show: