SysExcelHelper Class [AX 2012]
The SysExcelHelper class helps in the creation of a Microsoft Office Excel workbook.
| Method | Description | |
|---|---|---|
| addWorksheet | Adds a worksheet to the workbook. |
| cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) |
| close | Closes the Microsoft Office Excel application and releases the resources. |
| createStyles | |
| equal | Determines whether the specified object is equal to the current one. (Inherited from Object.) |
| getApplication | Gets the Microsoft Office Excel application instance managed by this class. |
| getFileExtension | Gets the default file name extension used for this version of Microsoft Office Excel. |
| getOfficeVersion | Gets the version of Microsoft Office Excel that is used on the system. |
| getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) |
| getWorkbook | Gets the Microsoft Office Excel workbook instance managed by this class. |
| getWorksheet | Gets the specified worksheet from the workbook. |
| handle | Retrieves the handle of the class of the object. (Inherited from Object.) |
| initialize | Initializes the Microsoft Office Excel application and creates one workbook with three empty worksheets. |
| launchExcel | Launches the Microsoft Office Excel application and presents the interface to the user. |
| new | Initializes a new instance of the SysExcelHelper 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.) |
| removeExtraWorksheets | Removes the extra worksheets created when the application is initialized. |
| save | Saves the workbook to the file name provided. |
| setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) |
| showGridlinesForActiveWorksheet | Shows or hides the gridlines for the active worksheet. |
| 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.) |
| ::construct | Initializes a new instance of the SysExcelHelper class. |
Community Additions
ADD
Show: