Desktop User Guides > Professional > Table scripting > Exporting tables > Microsoft Excel tables export
Microsoft Excel tables export
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.
UNICOM Intelligence Reporter
Microsoft Office 2007 or later (Microsoft Office must be activated)
Office 2007 or later. Unlike the PowerPoint Export component, which use automation in a VBScript, the Excel Export component uses a Visual Basic for Applications (VBA) macro for the export, because it provides superior performance when exporting to Excel. The macro is temporarily inserted into Excel and removed at the end of the export process.
This requires a security setting to be set. To set it, see Enabling security access for Microsoft Excel, Word, and PowerPoint exports.
See also
Microsoft Excel tables export formatting
Microsoft Excel tables export properties
Microsoft Excel tables export: Interactive mode
Exporting charts using Microsoft Excel custom chart types
Exporting tables