.. highlightlang:: us

.. index:: excel_sheet_put_rows

.. _excel_sheet_put_rows:

excel_sheet_put_rows
====================

.. us.tag  excel_sheet_put_rows NOTREADYENGLISH excel excel-write New550

:ref:`excel_sheet_put_rows` writes data starting at the current position to
an Excel sheet in the Biff 12 format (Excel 2007, Extension .xlsx).

.. function::  nRows = excel_sheet_put_rows(oSheet, rmVal)
    nRows = excel_sheet_put_rows(oSheet, smStr)
    nRows = excel_sheet_put_rows(oSheet, rmVal, smStr)
    nRows = excel_sheet_put_rows(oSheet, rmVal, rmStyleIndex)
    nRows = excel_sheet_put_rows(oSheet, smStr, rmStyleIndex)
    nRows = excel_sheet_put_rows(oSheet, rmVal, smStr, rmStyleIndex)

.. us.return

**Return Value**

*nRows*.

.. us.params

**Parameters**

.. uparam:: oSheet

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

.. uparam:: rmVal

   *rmVal* is a real matrix. The number of columns must match the number
   of columns specified in :ref:`excel_sheet_create`.

.. uparam:: smStr

   *smStr* is a string matrix.  The number of columns must match the number
   of columns specified in :ref:`excel_sheet_create`.

   To write an empty cell set the cell value to "\\t". 

   If the cell value is "" the element of *rmVal* is written to the file.

.. uparam:: rmStyleIndex

   *rmStyleIndex* is a matrix with style indices. See :ref:`excel_create`
   for an example.

.. us.history

**History**

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

   * - Version
     - Description
   * - 5.5.0
     - New

.. seealso::
   :ref:`overview-excel-files`,
   :ref:`excel_create`,
   :ref:`excel_sheet_create`,
   :ref:`excel_sheet_get_rows`

:sub:`id-1358086`