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.

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.

History

Version	Description
5.5.0	New

See also

Overview Excel Files, excel_create, excel_sheet_create, excel_sheet_get_rows

_id-1358086