Our powerful JS Calendar component


Post by Craig5117 »

Is it possible to export events from the Calendar to an excel document based on a date range or a single day?


Post by mats »

It's not yet supported but we have this ticket open to look into it! https://github.com/bryntum/support/issues/1567


Post by Craig5117 »

That would be fantastic!

The tricky issue is dealing with the recurring events since the calendar handles all the calculations for that. Being able to export the events with the recurring events already handled would be ideal.

Is there an estimate for when that release might be happening?

And if it is going to be a while, is there a way that we could handle parsing the recurrenceRule that would allow us to build our own export file?


Post by mats »

Is there an estimate for when that release might be happening?

Currently we don't have this on the roadmap, backlog is pretty full until 5.0. That said, we're open for feature sponsorship if you need this urgently.

And if it is going to be a while, is there a way that we could handle parsing the recurrenceRule that would allow us to build our own export file?

Yes you could handle this yourselves by using https://bryntum.com/docs/scheduler/#Scheduler/data/mixin/EventStoreMixin#function-getEvents to grab the relevant events in a time span


Post by Animal »

The list mode is a Grid

https://www.bryntum.com/docs/calendar/#Calendar/widget/EventList

There is an (experimental) export feature which is available on an unsupported basis in the Grid package.

Docs: https://www.bryntum.com/docs/calendar/#Grid/feature/experimental/ExcelExporter

Demo of how to use it: https://www.bryntum.com/examples/grid/exporttoexcel/

So you have to include zipxls as described

	<script src="zipcelx.js"></script>

Then in your app configure your Calendar:

    modes : {
        list : {
            features : {
                excelExporter : true
            },
            columns : [... your extra columns]
        }
    },

    tbar : {
        items : {
            export : {
                type : 'button',
                text : 'Export',
                onClick() {
                    calendar.modes.list.features.excelExporter.export();
                }
            }
        }
    },

And the list view can show a range. Right click on its headers (it is also configurable):

Screenshot 2021-09-10 at 15.25.59.png
Screenshot 2021-09-10 at 15.25.59.png (68.89 KiB) Viewed 683 times

Post Reply