Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


Exports the contents of a dataset as an Excel spreadsheet, prompting the user to save the file to disk. Uses the same format as the system.dataset.toExcel function. To write silently to a file, you cannot use the dataset.export* functions. Instead, use the toExcel() function.

Client permissions restrictions


system.dataset.exportExcel(filename, showHeaders, dataset, [nullsEmpty])

  • Parameters

String filename - A suggested filename to save as.

Boolean showHeaders - If true, the spreadsheet will include a header row.

Dataset | List[Dataset] dataset - Either a single dataset, or a list of datasets. When passing a list, each element represents a single 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]

  • Returns

String - The path to the saved file, or None if the action was canceled by the user.

  • Scope

Vision Client

titleCode Examples
Code Block
titleCode Snippet
# This snippet prompts the user to save the data currently displayed in a Table component to an Excel-compatible spreadsheet file. It opens the file after a successful save.
table = event.source.parent.getComponent("Table")
filePath = system.dataset.exportExcel("data.xlsx", 1,
if filePath != None:"file://"+filePath)

system dataset exportExcel, dataset.exportExcel