Professional > Table scripting > Exporting tables > Microsoft Word tables export
 
Microsoft Word tables export
UNICOM Intelligence Reporter provides a Word Export component, which enables you to export tables and charts to Microsoft Word. The component has been designed to create output in Word that looks good, is suitable for printing, and easy to customize. To use the Word Export component, you need to have Microsoft Office 2007 or later installed.
You can optionally export charts as well as or instead of tables. The charts are created using Excel, which means that you need to have both Word and Excel installed to be able to use this option. If you export both charts and tables, the charts are placed before or after the table to which they relate, depending on the display option chosen. For details of how data is displayed in charts, see Creating charts.
Note You can greatly 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 on your system, you can install it from the Microsoft Office installation package.
Word 2007 and above. Unlike the PowerPoint Export component, which use automation in a VBScript, the Word Export component uses a Visual Basic for Applications (VBA) macro for the export, because it provides superior performance when exporting to Word (up to 20 times faster than VBScript automation). The macro is temporarily inserted into the Word template and removed at the end of the export process. The macro takes as input the tables XML (which defines the tables to be exported) and the properties XML (which defines the custom properties), and a reference to the ActiveX control. The macro then generates the Word document using the Word object model (and the Excel object model for display options including charts). The macro uses the Windows clipboard to copy and paste the annotations, in order to retain any HTML formatting. The copy operation is implemented using a method in the Active X control, and this means a reference to the control is passed into the macro.
This requires a security setting to be set: see Enabling security access for Microsoft Excel, Word, and PowerPoint exports.
For more information, see:
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q282/8/30.ASP&NoWebContent=1
"Chart Error" text in the Word document instead of charts
The Word Export uses Excel to create the charts, so you must have Excel 2007 or later installed on your desktop computer in order to be able to export charts to Word. If you get this error text for all charts, the first thing to do is to check that you have Excel installed. If it is installed, check that it has been installed with the option to embed Excel charts enabled. If this option is not enabled, it would explain the error. You can tell whether this option is enabled as follows:
1 Start a new document in Word.
2 From the Insert menu, choose Object.
3 From the list of object types, select Microsoft Excel Chart.
4 Click OK.
If this fails, it generally means that the option is not enabled and you will need to install the option before you can export charts to Word. If this succeeds, it means that the chart error is caused by some other problem and may be related to a specific table.
Requirements
UNICOM Intelligence Reporter
Microsoft Office 2007 or later (Microsoft Office must be activated)
See also
Microsoft Word tables export properties
Microsoft Word tables export - interactive mode
Formatting the output in Microsoft Word
Exporting tables