Contents

Overview

You can export a selected calendar, or all calendars, to Microsoft Excel. The exported data can be saved as an Excel workbook, or any other file type that Excel is capable of saving to, such as XML, HTML, or plain text. This feature requires Excel 2003 or later.

The export calendar window.

Selecting a Calendar To Export

Events belonging to the selected calendar will be exported. If you'd like to export events belonging to all calendars, select the "All calendars" option from the list. Or, to export only those calendars that have checkmarks in the Calendar List, select the "Visible calendars" option.

Selecting the calendar to export.

Date Range

Only events falling within the specified range of dates will be exported.

Select a range of dates to export.

You can specify an automatic date range, such as the current month or the dates currently displayed in the Calendar View by selecting an option from the list. You can also select a custom date range by entering your own start and end dates. Dates can be typed or selected from a calendar by using the drop-down button.

You can select a different automatic date range type.

Exporting Event Appearances

You can choose to format the output to match the event appearance settings.

You can choose to include event appearance settings when exporting to Excel.

Each row will be formatted as closely as possible to the format specified in VueMinder Calendar. Note, this will not include secondary background colors or gradient patterns, since these settings are not supported by Excel 2003.

Exporting

After you've selected a calendar to export and a date range, click the Export button. The export results will update after all the applicable events have been exported. If you have many events, this could take several seconds.

The export results will update as the export is processed.


After all events have been exported to Excel, the exported workbook will display in Excel. Note, the exported workbook has not been saved yet. If you'd like to save the exported workbook, you can save it from within Excel, as you normally would for other spreadsheets.

After exporting, you can save the results to an Excel workbook.


You can also save the results to a different file type, such as XML or HTML, by selecting the desired file type from the list. The list of file types may vary depending on your version of Excel.

You can select a different file type to save the results to.

Example Export

The following screenshot shows an example of exported events when saved to an Excel Workbook.

An example exported workbook.

The same data was exported to HTML. Here's an example of the data when displayed in Internet Explorer:

An example of the events exported to HTML.

Have a Question?

Your email address:

Question/comments:

Copyright © 2009 VueSoft. All rights reserved.