ExcelWriteΒΆ
The ExcelWrite function saves data in an Excel file format.
-
bool = ExcelWrite(ssFileName, smMatrix, smType)
-
bool = ExcelWrite(ssFileName, smMatrix)
-
bool = ExcelWrite(ssFileName, rmMatrix)
Return Value
If the function succeeds, the return value is TRUE (1); otherwise it is FALSE (0).
Parameters
-
ssFileName
ssFileName is the complete file name, which usually has the extension
.XLS
.
-
smType
smType is a string matrix that defines the type of the corresponding elements in the parameter smMatrix.
Value Meaning "I"
The corresponding element in smMatrix will be converted into a 16 bit unsigned integer number. ""
(empty string)The corresponding element in smMatrix will be converted into a real number. "S"
The corresponding element in smMatrix will be written as a string.
-
smMatrix
smMatrix is a string matrix.
-
rmMatrix
rmMatrix is a real matrix.
Comment
The maximum number of rows is limited to 16384 and the maximum number of columns is limited to 255. ExcelWriteEx can write XLSX Excel files with up to one millon data rows.
See also
id-1241313