Insert Excel contents: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(6 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 12: Zeile 12:
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnInsertExcel_32.png|rxbtnInsertExcel_32.png|link=Insert_a_table_from_a_file]] [[Insert_a_table_from_a_file|Insert a table from a file]]</div>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnInsertExcel_32.png|rxbtnInsertExcel_32.png|link=Insert_a_table_from_a_file]] [[Insert_a_table_from_a_file|Insert a table from a file]]</div>
 
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_a_table_from_a_file]]-->
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_a_table_from_a_file]]
 
Use this function to insert a table from an Excel file as a linked firesys table object in Word. <small>'''[[Insert_a_table_from_a_file|more]]'''</small>
Use this function to insert a table from an Excel file as a linked firesys table object in Word. <small>'''[[Insert_a_table_from_a_file|more]]'''</small>
----
----
Zeile 20: Zeile 18:
|style="width:30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
|style="width:30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:rxbtnInsertDirectFromExcel_32.png|Insert_table_directly_from_the_selected_Excel_range]] [[Insert_table_directly_from_the_selected_Excel_range|Insert table directly from the selected Excel range]]</div>
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:rxbtnInsertDirectFromExcel_32.png|Insert_table_directly_from_the_selected_Excel_range]] [[Insert_table_directly_from_the_selected_Excel_range|Insert table directly from the selected Excel range]]</div>
 
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_table_directly_from_the_selected_Excel_range]]-->
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_table_directly_from_the_selected_Excel_range]]
 
With this function you insert the content of a range you have selected in Excel directly into Word as a linked firesys object. <small>'''[[Insert_table_directly_from_the_selected_Excel_range|more]]'''</small>
With this function you insert the content of a range you have selected in Excel directly into Word as a linked firesys object. <small>'''[[Insert_table_directly_from_the_selected_Excel_range|more]]'''</small>
-----
-----
Zeile 28: Zeile 24:
|style="width:30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
|style="width:30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnTextData_32.png|link=Insert_data_in_text_from_file]] [[Insert_data_in_text_from_file|Insert data in text from file]]</div>
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnTextData_32.png|link=Insert_data_in_text_from_file]] [[Insert_data_in_text_from_file|Insert data in text from file]]</div>
 
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_data_in_text_from_file]]-->
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_data_in_text_from_file]]
 
Use this function to insert the content of a single cell as a linked firesys object in the body text of your Word document.  <small>'''[[Insert_data_in_text_from_file|more]]'''</small>  
Use this function to insert the content of a single cell as a linked firesys object in the body text of your Word document.  <small>'''[[Insert_data_in_text_from_file|more]]'''</small>  
-----
-----
Zeile 38: Zeile 32:
|style="width:30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
|style="width:30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnTextDataDirect_32.png|link=Daten_im_Text_direkt_aus_markierter_Zelle_einfügen]] [[Daten_im_Text_direkt_aus_markierter_Zelle_einfügen|Insert data in text directly from the selected Excel cell]]</div>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnTextDataDirect_32.png|link=Insert_data_in_text_directly_from_the_selected_Excel_cell]] [[Insert_data_in_text_directly_from_the_selected_Excel_cell|Insert data in text directly from the selected Excel cell]]</div>
 
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_data_in_text_directly_from_the_selected_Excel_cell]]-->
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Daten_im_Text_direkt_aus_markierter_Zelle_einfügen]]
Use this function to insert the content of a single cell that you have selected in Excel directly as a linked firesys object into the body text of your Word document. <small>'''[[Insert_data_in_text_directly_from_the_selected_Excel_cell|more]]'''</small>
 
Use this function to insert the content of a single cell that you have selected in Excel directly as a linked firesys object into the body text of your Word document. <small>'''[[Daten_im_Text_direkt_aus_markierter_Zelle_einfügen|more]]'''</small>
----
----


<!-- <div style="padding: 4px; font-family: sans-serif; font-size:130%; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:X.png|link=Daten_im_Text_direkt_aus_markierter_Zelle_einfügen]] [[Daten_im_Text_direkt_aus_markierter_Zelle_einfügen|Daten im Text direkt aus markierter Zelle einfügen]]</div> -->
|style="width:30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
|style="width:30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:X.png|Daten_im_Text_mit_Optionen_einfügen]] [[Daten_im_Text_mit_Optionen_einfügen|Insert data in text directly from the selected Excel cell with options]]</div>
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:Daten_Optionen_32.png|Insert_data_in_text_directly_from_the_selected_Excel_cell_with_options]] [[Insert_data_in_text_directly_from_the_selected_Excel_cell_with_options|Insert data in text directly from the selected Excel cell with options]]</div>
 
<!--[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Insert_data_in_text_directly_from_the_selected_Excel_cell_with_options]]-->
[[Datei:Dummybild.jpeg|left|175px|Testbild|link=Daten_im_Text_mit_Optionen_einfügen]]
Use this function to insert the content of a single cell as a linked firesys object with a different unit or as an absolute value into the body text of your Word document.  <small>'''[[Insert_data_in_text_directly_from_the_selected_Excel_cell_with_options|more]]'''</small>  
 
Use this function to insert the content of a single cell as a linked firesys object with a different unit or as an absolute value into the body text of your Word document.  <small>'''[[Daten_im_Text_mit_Optionen_einfügen|more]]'''</small>  
-----
-----


Zeile 65: Zeile 54:
== See also  ==
== See also  ==


[[Datei:Navigation_hoch.svg|link=]]  [[Inhalte_aus_Excel_in_Word_einfügen|Insert contents from Excel in Word]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Insert_contents_from_Excel_into_Word|Insert contents from Excel in Word]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Übersicht_Excel-Daten-Manager|The Excel data manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Overview_of_the_Excel_data_manager|The Excel data manager]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Excel-Daten-Manager_-_Die_Aktualisierungsfunktionen|Update Excel contents]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Excel_data_manager_–_the_update_functions|Update Excel contents]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Die_Änderungsanzeige_in_Excel|The change display in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_change_display_in_Excel|The change display in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Einstellungen_in_Word_-_Daten_aus_Excel|The firesys settings in Word for data from Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Settings_in_Word_–_data_from_Excel|The firesys settings in Word for data from Excel]]  <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Word Excelinhalte-hinzufügen]]
[[Kategorie:English-Word Excelinhalte-hinzufügen]]

Aktuelle Version vom 2. Juli 2020, 14:18 Uhr


RxbtnFinalPreflight 64.png
Insert Excel contents

You can use these functions to insert Excel tables as linked firesys table objects or individual cells as data in text elements in your corporate design.

RxbtnFinalPreflight 64.png

Use this function to insert a table from an Excel file as a linked firesys table object in Word. more


With this function you insert the content of a range you have selected in Excel directly into Word as a linked firesys object. more


Use this function to insert the content of a single cell as a linked firesys object in the body text of your Word document. more



Use this function to insert the content of a single cell that you have selected in Excel directly as a linked firesys object into the body text of your Word document. more


Use this function to insert the content of a single cell as a linked firesys object with a different unit or as an absolute value into the body text of your Word document. more





See also

Navigation hoch.svg Insert contents from Excel in Word
Navigation rechts.svg The Excel data manager
Navigation rechts.svg Update Excel contents
Navigation rechts.svg The change display in Excel
Navigation rechts.svg The firesys settings in Word for data from Excel

Further contents

firesys website
Customer area
YouTube