This example demonstrates how to export the Scheduler events to an Excel file format at client-side.
More Details...
| |
12:00 AM | | 1:00 AM | | 2:00 AM | | 3:00 AM | | 4:00 AM | | 5:00 AM | | 6:00 AM | | 7:00 AM | | 8:00 AM | | 9:00 AM | | 10:00 AM | | 11:00 AM | | 12:00 PM | | 1:00 PM | | 2:00 PM | | 3:00 PM | | 4:00 PM | | 5:00 PM | | 6:00 PM | | 7:00 PM | | 8:00 PM | | 9:00 PM | | 10:00 PM | | 11:00 PM | |
| Explosion of Betelgeuse Star 4:00 AM - 5:30 AM Space Centre USA Alien Civilization 8:30 AM - 10:30 AM Space Centre USA | The Cycle of Seasons 12:00 AM - 2:00 AM Research Centre of USA Thule Air Crash Report 6:30 AM - 8:30 AM Newyork City Space Galaxies and Planets 11:30 AM - 1:00 PM Space Centre USA | Blue Moon Eclipse 4:00 AM - 5:30 AM Space Centre USA The Cycle of Seasons 9:00 AM - 10:30 AM Research Centre of USA | Meteor Showers in 2021 7:30 AM - 9:00 AM Space Centre USA | Lifecycle of Bumblebee 12:30 AM - 2:00 AM San Fransisco Mysteries of Bermuda Triangle 4:00 AM - 5:30 AM Bermuda Milky Way as Melting pot 6:30 AM - 8:30 AM Space Centre USA Alien Civilization 10:30 AM - 12:30 PM Space Centre USA | Glaciers and Snowflakes 5:30 AM - 7:00 AM Himalayas Sky Gazers 9:00 AM - 10:30 AM Greenland | Life on Mars 3:30 AM - 4:30 AM Space Centre USA Facts of Humming Birds 7:00 AM - 9:00 AM California | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|
Description
In this example, the Scheduler events data are exported to an Excel file by making use of the public method
exportToExcel. By default, the whole event collection bound to the Scheduler gets exported as an excel file. To
export only specific events of Scheduler, you need to pass the custom data collection as a parameter to the
exportToExcel method. This method accepts the export options as its arguments such as fileName, exportType,
fields, customData, and includeOccurrences. The fileName denotes the name to be given for the exported file and
the exportType allows you to set the format of the excel file to be exported either as .xlsx or .csv. The custom
or specific field collection of event dataSource to be exported can be provided through fieldsInfo option and the
custom data collection can be exported by passing them through the customData option. There also exists option
to export individual instances of the recurring events to an excel file, by setting true or false to the
includeOccurrences option, denoting either to include or exclude the occurrences as separate instances on an
exported excel file.
Module Injection
To start using Excel exporting functionality in Scheduler, you need to import the ExcelExport module from
@syncfusion/ej2-schedule package and then inject it using the Schedule.Inject(ExcelExport)
method.