.. highlightlang:: us

.. index:: excel_sheet_get_row_type

.. _excel_sheet_get_row_type:

excel_sheet_get_row_type
========================

.. us.tag  excel_sheet_get_row_type NOTREADYENGLISH excel-read New550

:ref:`excel_sheet_get_row_type` returns a real matrix with the data types of
a section of an Excel sheet.

.. function::  rmType = excel_sheet_get_row_type(oSheet)

.. us.return

**Return Value**

*rmType* is a real matrix. The matrix contains the data type values of the 
segment of a sheet. Before this function is invoked :ref:`excel_sheet_get_rows` 
must be invoked to load the data. The number of columns is identical to the 
number of columns of the sheet. The number of rows is identical to the return 
value of :ref:`excel_sheet_get_rows`. The elements contain the data types of
the corresponding spread sheet cells:

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

   * - Value
     - Meaning
   * - 0
     - Number field.
   * - 2
     - String field.
   * - 3
     - Blank (empty) field.

.. us.params

**Parameters**

.. uparam:: oSheet

   *oSheet* is an object created by :ref:`excel_sheet_open`.

.. us.comment

**Comment**

Before this function is invoked :ref:`excel_sheet_get_rows` must be invoked.

.. us.example

**Example**

See :ref:`excel_open`.

.. us.history

**History**

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

   * - Version
     - Description
   * - 5.5.0
     - New

.. seealso::
   :ref:`overview-excel-files`,
   :ref:`excel_sheet_get_rows`,
   :ref:`excel_sheet_get_row_type2`

:sub:`id-31853`