Config File 7 Exporting to Excel

Every graphical object in a form can be exported into an Excel spreadsheet. Please note that the Excel file must be already created with 3 sheets named "elements", "relationship", and "model". File extensions should be .xlsx, .xlt, or .xls. If you would like to configure what is exported to an Excel file, please follow the instructions below:

For simple objects, provide the following properties (case insensitive):

• excelSheet [string]: the name of your sheet in an Excel file
• excelCell [string]: reference number for a cell in an Excel sheet. It can be specified in any syntax allowed by Excel like "D9" or "$D$9" or by using any cell name recorded in the sheet.
• excelCellType [string]: type of Excel cell. Must be one of:
  • string (the default)
  • boolean
  • numeric
  • formula
• excelDefault [string]: specifies what to do if the value to be exported to Excel is null (for example, an empty property value). Must be one of:
  • blank: the cell will be blank
  • zero: the cell will contain a 0 in numeric cells, an empty string in string and formula cells, and false in boolean cells

For tables, the following properties must be provided in the "table" section:

• excelSheet [string]: the name of your sheet in an Excel file
• excelFirstLine [integer]: the number of the first Excel line where the table lines should be inserted.

For columns, the following properties must be provided in the "column" section:

• excelColumn [string]: reference number of an Excel column.
• excelCellType [string]: type of Excel cell. Must be one of:
  • string (the default)
  • boolean
  • numeric
  • formula
• excelDefault [string]: specifies what to do if the value to be exported to Excel is null (for example, an empty property value). Must be one of:
  • blank: the cell will be blank
  • zero: the cell will contain a 0 in numeric cells, an empty string in string and formula cells and false in boolean cells

If an Excel property is declared in any graphical object, then the "export to Excel" button will be appear in the form display window, otherwise it won't appear.