ExcelExporter
Feature
A feature that allows exporting Scheduler data to Excel or CSV without involving the server. It uses TableExporter class as data provider, 3rd party provider to generate XLS files, and Microsoft XML specification.
import WriteExcelFileProvider from '../../lib/Grid/feature/experimental/xlsproviders/WriteExcelFileProvider.js';
new Scheduler({
features : {
excelExporter : {
xlsProvider : WriteExcelFileProvider
}
}
});
Here is an example of how to add the feature:
const scheduler = new Scheduler({
features : {
excelExporter : {
// Choose the date format for date fields
dateFormat : 'YYYY-MM-DD HH:mm',
exporterConfig : {
// Choose the Resource fields to include in the exported file
columns : [{ text : 'Staff', field : 'name' }],
// Choose the Event fields to include in the exported file
eventColumns : [
{ text : 'Task', field : 'name' },
{ text : 'Starts', field : 'startDate', width : 140 },
{ text : 'Ends', field : 'endDate', width : 140 }
]
}
}
}
});
And how to call it:
scheduler.features.excelExporter.export({
filename : 'Export',
exporterConfig : {
columns : [{ text : 'Staff', field : 'name' }]
}
})
This feature is disabled by default.
Configs
Configs are options you supply in a configuration object when creating an instance of this class-
Exporter class. Must subclass ScheduleTableExporter
-
Configuration object for exporter class.
-
Internal listeners, that cannot be removed by the user.
-
If this config is true, exporter will convert all empty values to ''. Empty values are:
- undefined, null, NaN
- Objects/class instances that do not have toString method defined and are stringified to [object Object]
- functions
-
Allows configuring MIME type of the exported CSV file
-
Defines how dates in a cell will be formatted
-
Set this config to
trueto export all exportable columns including hidden columns as well. -
Name of the exported file
-
The widget which this plugin is to attach to.
Has a corresponding runtime client property.
-
Set to
falseto disable localization of this object.
Properties
Properties are getters/setters or publicly accessible variables on this class-
Identifies an object as an instance of Events class, or subclass thereof.
-
Identifies an object as an instance of ExcelExporter class, or subclass thereof.
-
Identifies an object as an instance of Localizable class, or subclass thereof.
-
A class property getter for the default values of internal properties for this class.
-
An empty array that can be used as a default value.
-
An empty object that can be used as a default value.
-
Identifies an object as an instance of ExcelExporter class, or subclass thereof.
-
Identifies an object as an instance of InstancePlugin class, or subclass thereof.
-
Returns a copy of the full configuration which was used to configure this object.
-
This property is set to
truebefore theconstructorreturns. -
This property is set to
trueon entry to the destroy method. It remains on the objects after returning fromdestroy(). If isDestroyed istrue, this property will also betrue, so there is no need to test for both (for example,comp.isDestroying || comp.isDestroyed). -
The Widget which was passed into the constructor, which is the Widget we are providing extra services for.
Has a corresponding client config.
-
Get the global LocaleHelper
-
Get the global LocaleManager
Functions
Functions are methods available for calling on the class-
This optional class method is called when a class is mixed in using the mixin() method.
-
Registers this class type with its Factory
-
Internal function used to hook destroy() calls when using thisObj
-
Internal function used restore hooked destroy() calls when using thisObj
-
Auto detaches listeners registered from start, if set as detachable
-
Internal function used to run a callback function after an event is triggered
-
Removes all listeners registered to this object by the application.
-
This will merge a feature's (subclass of InstancePlugin) keyMap with it's client's keyMap.