UNICOM Intelligence Reporter comes with an Excel Export component, which enables you to export tables and charts to Microsoft Excel. The component has been designed to create output in Excel that is suitable for printing and easy to manipulate. To use the Excel Export component, you need to have Microsoft Office 2007 or later installed.

By default, each table is exported as a single table to a separate Excel worksheet. However, you can optionally choose to export each type of cell contents to a separate table on the same worksheet. You select this option by setting the SplitCells export property to True. This option is useful when you want to perform calculations on the output or create your own charts in Excel.

You can optionally choose to export charts. The export creates the charts on a separate worksheet immediately following the worksheet that contains the related table. For details of how data is displayed in charts, see Creating charts. You select the option to create charts by setting the DisplayCharts export property to True.

The worksheets are named T1, T2, T3, etc. This is designed to reduce the length of the worksheet names, in order to maximize the number of worksheet tabs that can be visible at once. The worksheets that contain charts are called T1_Ch, T2_Ch, T3_Ch, etc. where T1, T2, and T3 are the names of the worksheets containing the tables to which they relate.

You can improve table export performance by selecting the Microsoft Office Document Image Writer as the default print driver when exporting to Office applications. If the print driver in not already installed, you can install it from the Microsoft Office installation package.