excel_sheet_put_rows

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

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)

Return Value

nRows.

Parameters

oSheet

oSheet is an object created by excel_sheet_open or excel_sheet_create.

rmVal

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

smStr

smStr is a string matrix. The number of columns must match the number of columns specified in 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.

rmStyleIndex

rmStyleIndex is a matrix with style indices. See excel_create for an example.

History

Version Description
5.5.0 New

id-1358086