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 file name.

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.

id-1241313