SysExcelHelper Class [AX 2012]

The SysExcelHelper class helps in the creation of a Microsoft Office Excel workbook.

class SysExcelHelper

Run On

Client

  MethodDescription
Gg928702.pubmethod(en-us,AX.60).gif addWorksheet Adds a worksheet to the workbook.
Gg928702.pubmethod(en-us,AX.60).gif cancelTimeOut Cancels a previous method call to the setTimeOut method. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif close Closes the Microsoft Office Excel application and releases the resources.
Gg928702.protmethod(en-us,AX.60).gif createStyles
Gg928702.pubmethod(en-us,AX.60).gif equal Determines whether the specified object is equal to the current one. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif getApplication Gets the Microsoft Office Excel application instance managed by this class.
Gg928702.pubmethod(en-us,AX.60).gif getFileExtension Gets the default file name extension used for this version of Microsoft Office Excel.
Gg928702.pubmethod(en-us,AX.60).gif getOfficeVersion Gets the version of Microsoft Office Excel that is used on the system.
Gg928702.pubmethod(en-us,AX.60).gif getTimeOutTimerHandle Returns the timer handle for the object. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif getWorkbook Gets the Microsoft Office Excel workbook instance managed by this class.
Gg928702.pubmethod(en-us,AX.60).gif getWorksheet Gets the specified worksheet from the workbook.
Gg928702.pubmethod(en-us,AX.60).gif handle Retrieves the handle of the class of the object. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif initialize Initializes the Microsoft Office Excel application and creates one workbook with three empty worksheets.
Gg928702.pubmethod(en-us,AX.60).gif launchExcel Launches the Microsoft Office Excel application and presents the interface to the user.
Gg928702.protmethod(en-us,AX.60).gif new Initializes a new instance of the SysExcelHelper class.
Gg928702.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.)
Gg928702.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.)
Gg928702.pubmethod(en-us,AX.60).gif objectOnServer Determines whether the object is on a server. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif owner Returns the instance that owns the object. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif removeExtraWorksheets Removes the extra worksheets created when the application is initialized.
Gg928702.pubmethod(en-us,AX.60).gif save Saves the workbook to the file name provided.
Gg928702.pubmethod(en-us,AX.60).gif setTimeOut Sets up the scheduled execution of a specified method. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif showGridlinesForActiveWorksheet Shows or hides the gridlines for the active worksheet.
Gg928702.pubmethod(en-us,AX.60).gif toString Returns a string that represents the current object. (Inherited from Object.)
Gg928702.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.)
Gg928702.pubmethod(en-us,AX.60).gif wait Pauses a process. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif xml Returns an XML string that represents the current object. (Inherited from Object.)
Gg928702.pubmethod(en-us,AX.60).gif Gg928702.static(en-us,AX.60).gif ::construct Initializes a new instance of the SysExcelHelper class.
Top

Use the SysExcelWorksheetHelper class to manage worksheets that are a part of the overall workbook.

Object Class
  SysExcelHelper Class

Community Additions

ADD
Show: