system.db.exportExcel

Deprecated by system.dataset.exportExcel in 8.1

If using Ignition 8.3, use system.vision.exportExcel instead.

Click here to learn more about system.dataset.exportExcel.

Description

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.

Syntax

system.dataset.exportExcel(filename, showHeaders, dataset)

• 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.

• Returns

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

• Scope

  • Client