Insert data in text from file: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
Zeile 1: Zeile 1:
Use this function to insert data from separate Excel cells into the body text in your Word document and constantly refresh it at a click.  
Use this function to insert data from separate Excel cells into the body text in your Word document and constantly refresh it at a click.  


{{Vorlage:Daten im Text aus Datei einfügen-English}}
{{Vorlage:Video-Daten im Text aus Datei einfügen-English}}


== See also  ==
== See also  ==

Aktuelle Version vom 19. März 2021, 12:44 Uhr

Use this function to insert data from separate Excel cells into the body text in your Word document and constantly refresh it at a click.


A detailed explanation of the individual steps

This is how you insert a data in text object directly from a file into Word with firesys:

  1. In Excel, highlight the cell that you want to add to Word as a linked data object in the body text.

  2. Give the selected cell a name as otherwise it cannot be imported.

  3. Save the Excel file.

  4. Repeat this procedure for each cell that you want to add to Word as a linked data object in body text.

  5. Go to Word and position the cursor where you want to insert the data in the document.

  6. On the “*Content” tab in the “Excel Data” group on the “Insert” menu and select “From file” from the “Data in text...” area.
    → A data selection dialogue opens..

  7. Select the Excel file containing the worksheet with the cell you require (“data source”).
    → The linktext assistant opens

  8. The linktext assistant opens.

  9. Select the worksheet containing the required cell.

  10. Select the cell using the name that you defined in Excel.

  11. If applicable, check “Set absolute value” if you want to add a number as an absolute value.

  12. Click on "OK".
    → The linktext assistant inserts the data from the selected Excel cell into your body text.

See also

Navigation hoch.svg An overview of inserting Excel contents
Navigation rechts.svg Insert a table directly from the selected Excel range
Navigation rechts.svg Insert data in text from a file
Navigation rechts.svg Insert data in text directly from the selected Excel cell
Navigation rechts.svg Insert data in text directly from the selected Excel cell with options

Further contents

firesys website
Customer area
YouTube