Skip to main content

Configure For Import

To import Excel files you will need to create a set of instructions that tells DecaSIM how to extract features from an Excel worksheet.

These instructions are saved as a SHEET SPEC and can be created in the: Dash Board -> Settings -> Excel Import Settings view ofDecaSIM

SHEET SPEC​

A SHEET SPEC comprises the following:

  • TARGET SHEET: The name of the worksheet in the workbook that is going to be processed and imported. This can either be the exact match sheet of just a reference label if you want to use pattern matching.
  • Sheet Pattern Match: Users can also specify a regex string pattern to identify the worksheet to import. This is useful when there is important information contained in the worksheet name that users wishes to parse.
  • HEADER ROW: The row number where processor will find the header row. This uses zero-based counting so the first row is row 0
  • Cell Config File: The name of the file containing the process configuration parameters. This should be defined and then uploaded. Any text editor can be used to create it. These docs contain detailed information on how to create a new Config File. In V3, these files can be created and edited in the decaSIM application.
  • File Type: The type of file that will be saved in DecaSIM; LAYOUT or OFFER file. We are working on being able to import DESIGN ASSET file types from Excel as well.