system.dataset.toExcel(showHeaders, dataset, [nullsEmpty], [sheetNames])
Boolean showHeaders - If True, the spreadsheet will include a header row. If False, the header row will be omitted.
Object dataset - A sequence of one or more datasets, one for each sheet in the resulting workbook.
Boolean nullsEmpty - If True, the spreadsheet will leave cells with NULL values empty, instead of allowing Excel to provide a default value like 0. Defaults to False. [Optional]
The following feature is new in Ignition version 8.0.16
to check out the other new features
List sheetNames - Expects a list of strings, where each string is a name for one of the datasets. When used, there must be an equal number of string names in
sheetName as there are datasets in the
dataset parameter. Names provided in this parameter may be sanitized into acceptable Excel sheet names. [Optional]
Array - A byte array representing an Excel workbook.
Gateway, Vision Client, Perspective Session