Steps For Transferring Excel Formatting into Word Tables

Context

You can use the standard formatting features in Microsoft Excel to format tables in Excel. When transferring the tables into Word documents, the formats assigned in Excel are also transferred.

In order to transfer the formatting of Excel tables into Word tables, proceed as follows:

Procedure

Create a data cache or open an existing data cache in Excel and format the resulting table in Excel. You can, for example, highlight cells or rows in different colors and assign character formats such as bold or italic.
Open the Word chapter, in which you want to include the table and choose Disclosure Management Table .
Select the datasource.
In the " Load Dataprovider " dialog open the respective data cache and select the data range.
Select one of the following template options:
- Excel Template: The system transfers the data cache data with all formatting information from Excel into Word. The table is available in your Word document as a Word table with the formatting assigned in Excel.
  Caution If you use the setting Yes for the parameter Do not Use Structured Word Styles for „Excel Template” Formatting, only formatting that you have applied manually will be transferred. Formatting assigned by means of Excel style templates are not transferred into Word.
- Word Template: The system transfers the data without any formatting from Excel into a Word table. The formatting defined in a Word template is assigned, see Inserting a Word Table and Selecting the Data Provider.
- No Template: The system transfers the data cache data into a Word table without any formatting.
You can apply format changes in Word. However, these changes are overwritten with the formats applied in Excel when you refresh the table. You can keep changes to the column width applied in Word.