How to Export Angular Scheduler Appointments to an Excel Document

Arun - Nov 8 '23 - - Dev Community

Learn how to export Angular Scheduler appointments to an Excel document. You will also learn how to export documents with custom fields, individual occurrences of recurring series, and custom event data. I will show you how to change the file name, file format, and column headers.

The Angular Scheduler, or Angular Event Calendar, is a fully featured event calendar component that helps users efficiently manage their time. It facilitates easy resource scheduling, rescheduling of events or appointments through editor pop-ups, drag-and-drop, and resizing actions.

The Scheduler allows you to export all its events to an Excel document by default. It also provides additional customization options to export custom event data collections. To use the Excel feature, import the ExcelExportService from the Syncfusion EJ2 Angular Schedule package and register it in the imports array of the ng module.

The Scheduler allows you to export all its events into an Excel format file using the exportToExcel client-side method. By default, it exports all the default fields of the Scheduler mapped through the eventSettings property.

To limit the number of fields in the exported Excel file, it provides an option to export only custom fields. To export custom fields alone, define the required fields through the ExportOptions interface and pass them as an argument to the exportToExcel method. By default, the Scheduler exports event data to an Excel file in .xlsx format, but you can also export data in CSV format.

Explore our tutorial videos: https://www.syncfusion.com/tutorial-videos

Download an example from GitHub: https://github.com/SyncfusionExamples/how-to-export-angular-scheduler-appointments-to-an-excel-document

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .