ExcelWriteEx

The ExcelWriteEx function saves data in an Excel file in the XLSX format.

bool = ExcelWriteEx(ssFileName, smMatrix, smType)
bool = ExcelWriteEx(ssFileName, smMatrix)
bool = ExcelWriteEx(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. Normal extension is .xlsx.

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 approx. 1 millin rows and 65000 columns.

Example

smData = ["Speed", "Torque";
          "rpm", "Nm";
          "1000.0", "10.5";
          "2000.0", "20.0"];
smType = ["S", "S";
          "S","S";
          "", "";
          "",""];
ExcelWriteEx("d:/a.xlsx", smData, smType)

id-1744635