Formats the contents of one or more datasets as an excel spreadsheet, returning the results as a string. Each dataset specified will be added as a worksheet in the Excel workbook. This function uses an xml-format for Excel spreadsheets, not the native Excel file format.
This scripting function has no Client Permission restrictions.
system.dataset.dataSetToExcel(showHeaders, datasets[, nullsEmpty])
Boolean showHeaders - If True (1), the spreadsheet will include a header row.
Object datasets - A sequence of datasets, one for each sheet in the resulting workbook.
Boolean nullsEmpty - If True (1), the spreadsheet will leave cells with NULL values empty, instead of allowing Excel to provide a default value like 0. Defaults to False. [Optional]
String - An Excel-compatible XML-based workbook, with one worksheet per dataset.