.. highlightlang:: us

.. index:: Edit=>Attachments
.. index:: y^excel-data-dialog

.. _diagram-more-diagram-functions-create-table-linked-to-excel-sheet:

Diagram=>More Functions=>Diagramm=>Create Table Linked to Excel Sheet
---------------------------------------------------------------------

Creates a UniPlot table that contains a defined area of an Excel table.
The Excel file is linked to the table using the file name.
The link is written to the table name as a field function.
The link refers only to the cell contents and not to the 
Formatting of the Excel table.

Press F9 to update the UniPlot table. The link can be edited with a right click
or a double click on the table object. 

.. image:: S:/uniplot-obj/images/excel_data_dialog-en.*

.. us.dlgitem

**File**
   Full name of the Excel file (XLSX, XLS).

.. us.dlgitem

**Table**
   Table name of the Excel file.

.. us.dlgitem

**Range**
   This parameter defines the cell range that is taken from the Excel spreadsheet. 
   The range is specified in the a1 reference format. A1:B5 
   defines, for example, cells A1 to B5. If the parameter is not
   specified, the entire table is loaded. The size is limited to 128 rows and
   columns.

.. us.dlgitem

**Position**
   Sets the insertion position in the a1 reference format. The default value is 
   A1. If, for example, the Excel table should be inserted in the third row 
   to make the first two lines available for other text, set the position to A3. 
   If no position is defined the table is inserted at position A1.

.. us.comment

**Comment**

**Comments**

If the Excel file is not available, the table is not updated. If the Excel file
is relatively large, the update may take a relatively long time. 
Try to keep the size of the linked Excel file as small as possible, so that the 
update time is not too long.

.. us.history

**History**

.. list-table::
   :header-rows: 1

   * - Version
     - Description
   * - R2018.9
     - New.

.. seealso::
   :ref:`@f{excel_data}`

:sub:`id-775934`