Contents
Strategic Partner Links
Sepasoft - MES Modules
Cirrus Link - MQTT Modules
Resources
Knowledge Base Articles
Inductive University
Forum
IA Support
SDK Documentation
SDK Examples
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 dataSetToExcel function.
This scripting function has no Client Permission restrictions.
system.dataset.exportExcel(filename, showHeaders, dataset[, nullsEmpty])
String filename - A suggested filename to save as.
boolean showHeaders - If true (1), the spreadsheet will include a header row.
Object[] dataset - A sequence of datasets, one for each sheet in the resulting workbook.
String - The path to the saved file, or None if the action was canceled by the user.
Client
# This snippet would prompt the user to save the data currently displayed in a Table component to an Excel-compatible spreadsheet file, and would open the file after a successful save. table = event.source.parent.getComponent("Table") filePath = system.dataset.exportExcel("data.xls", 1, table.data) if filePath != None: system.net.openURL("file://"+filePath)