Ignition User Manual 7.9

Search

Contents




Strategic Partner Links

Sepasoft - MES Modules
Cirrus Link - MQTT Modules

Resources

Knowledge Base Articles
Inductive University
Forum
IA Support
SDK Documentation
SDK Examples

All Manual Versions

Ignition 8
Ignition 7.9
Ignition 7.8

Versions Compared

Old Version 13

changes.mady.by.user Robert McKenzie

Saved on

compared with

New Version Current

changes.mady.by.user Robert McKenzie

Saved on

Key

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


Scripting_function



Panel
titleDescription

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.


Panel
titleClient Permission Restrictions

This scripting function has no Client Permission restrictions.


Panel
titleSyntax

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

  • Parameters

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.

New_in
Version7.9.8



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]

  • Returns

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

  • Scope

Client



Panel
titleCode Examples


Code Block
languagepy
titleCode Snippet
# 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)