.. highlightlang:: us

.. _excel_open:

excel_open
==========

.. index:: excel_open

.. us.tag  excel_open NOTREADYGERMAN excel excel-read New550

:ref:`excel_open` öffnet eine Excel-Datei zum Lesen.

.. function::  oExcel = excel_open(ssFile)

.. us.return

**Returnwert**

*oExcel* ist ein UniScript Objekt oder falls ein Fehler auftritt der Wert 0.

.. us.params

**Parameter**

.. uparam:: ssFile

   *ssFile* ist der Name der Excel-Datei. 

.. us.comment

**Kommentar**

Um die Excel-Datei zu schließen, rufen Sie :ref:`excel_close` auf.

.. us.example

**Beispiel**

::

   def MyExcelRead(ssName)
   {
       oExcel = excel_open(ssName);
       if (oExcel == 0) {
           MessageBoxError("Cannot open file %s", ssName);
           return "";
       }
       oSheet = excel_sheet_open(oExcel, 1); // open the first sheet.
       rvSize = excel_sheet_get_size(oSheet);
       nRead = excel_sheet_get_rows(oSheet, 100); // read the first 100 rows
       rmType = excel_sheet_get_row_type(oSheet);
       rmData = excel_sheet_get_row_num(oSheet);
       rmString = excel_sheet_get_row_str(oSheet);
       excel_sheet_close(oSheet);
       excel_close(oExcel);
       return rmString;
   }

.. us.history

**History**

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

   * - Version
     - Beschreibung
   * - 5.5.0
     - Neu.

.. seealso::
   :ref:`uberblick-excel-dateien`
   :ref:`excel_sheet_open`,
   :ref:`excel_get_sheetnames`,
   :ref:`excel_get_style_index`,
   :ref:`excel_get_style_map`,
   :ref:`excel_sheet_close`,
   :ref:`excel_sheet_get_rows`,
   :ref:`excel_sheet_get_row_num`,
   :ref:`excel_sheet_get_row_str`,
   :ref:`excel_sheet_get_row_style`,
   :ref:`excel_sheet_get_row_type`,
   :ref:`excel_close`

:sub:`id-1565306`