v7.3.0
SupportExamplesFree Trial

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.

This class requires a 3rd party library to export to XLSX

No results

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
  • csvMimeType : Stringtext/csv
    internal
    ExcelExporter

    Allows configuring MIME type of the exported CSV file

  • Defines how dates in a cell will be formatted

  • Set this config to true to 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 false to disable localization of this object.

Properties

Properties are getters/setters or publicly accessible variables on this class
  • isEvents : Booleantrue
    READONLY
    static
    ADVANCED
    Events
    Identifies an object as an instance of Events class, or subclass thereof.
  • isExcelExporter : Booleantrue
    READONLY
    static
    ADVANCED
    Identifies an object as an instance of ExcelExporter class, or subclass thereof.
  • isLocalizable : Booleantrue
    READONLY
    static
    ADVANCED
    Localizable
    Identifies an object as an instance of Localizable class, or subclass thereof.
  • properties : Object
    internal
    static
    ExcelExporter

    A class property getter for the default values of internal properties for this class.

  • emptyArray : Array
    internal
    READONLY
    ExcelExporter

    An empty array that can be used as a default value.

  • emptyObject : Object
    internal
    READONLY
    ExcelExporter

    An empty object that can be used as a default value.

  • isExcelExporter : Booleantrue
    READONLY
    ADVANCED
    Identifies an object as an instance of ExcelExporter class, or subclass thereof.
  • isInstancePlugin : Booleantrue
    READONLY
    ADVANCED
    ExcelExporter
    Identifies an object as an instance of InstancePlugin class, or subclass thereof.
  • config : Object
    READONLY
    ADVANCED
    ExcelExporter

    Returns a copy of the full configuration which was used to configure this object.

  • This property is set to true before the constructor returns.

  • isDestroying : Boolean
    READONLY
    ADVANCED
    ExcelExporter

    This property is set to true on entry to the destroy method. It remains on the objects after returning from destroy(). If isDestroyed is true, this property will also be true, so there is no need to test for both (for example, comp.isDestroying || comp.isDestroyed).

  • client : Widget
    READONLY
    ADVANCED
    ExcelExporter

    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
  • onClassMixedIn( )
    internal
    static
    ExcelExporter

    This optional class method is called when a class is mixed in using the mixin() method.

  • initClass( )
    static
    ADVANCED
    ExcelExporter

    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

  • doDestroy( )
    internal
    Events

    Auto detaches listeners registered from start, if set as detachable

  • once( )
    private
    Events

    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.

Events

Events are triggered for certain actions in this class and can be listened for to react to those actions in your code

Event handlers

Event handlers are callbacks called as a result of certain actions in this class
id: excelExporter

Source path

Scheduler/feature/experimental/ExcelExporter.js

Demo

examples/exporttoexcel

Contents