Follow

Excel: Export data to Word

Data can be exported to Word in two forms: as text or image.

  • If a single cell is selected in Excel and a text range is selected in Word, the user can choose between exporting it's content as text or image.
      1. In the case of text, data is exported at the selected location as a Word field (similar to what is generally used for cross references) linked to the source Excel cell (see picture below).
      2. In the case of image, data is exported at the selected location as an image.
  • If a chart or range of cells is selected in Excel, or if a shape is selected in Word, an image will be exported to Word.

Exporting as a picture provides large savings in file size and the resulting shape can latter be updated directly from Word through the Update button.

 Options:

  • If a shape is selected in the active Word document, the exported picture will be placed in the upper left corner of this shape.
  • If a table is selected in the active Word document, the picture will be inserted in the first selected cell.
  • Re-size and Export: If this button is pressed, the chart/table is re-sized before it's exported.
  • Re-size and Export: If a table is selected, the first column width is modified so that after the export the entire width of the table matches the width of the insertion location (either page width, column width, shape width...).
  • Re-size and Export: If a chart is selected, the width of the chart is modified to match the width of the shape currently selected in the insertion location.

 Technical details:

 The table/chart is pasted as enhanced Metafile, with a fixed re-size ratio (to maintain a fixed font size across exported tables and charts).

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk