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