Liquid Studio Documentation
Data Mapping / Data Mapper Functions / Excel Target
In This Topic
    Excel Target
    In This Topic

    Function Name
    Excel Data Target
    Category
    Excel
    Icon
    Description
    Writes data to an Excel Spreadsheet (Worksheet, Table or Range).
    Inputs
    Filename Source file to read data from, if this input is not connected then the filename provided in the 'Default Source File' property
    Row A row is create for each line read form the source file
    Child Items Row contain a number of child items that reflect the fields defined when the component is created.
    Outputs
    None
    Properties
    Default Source File The default data file to read from. This is used if the input connection point 'Filename' is not connected.
    Store Relative Indicates if paths should be stored relative to the transform, or as absolute paths.
    Execution Order If the transform contains multiple Output Components then this determines the order in which they are executed

     

    Creating an Excel File Target

    When the Excel Writer component is dragged onto a transform a setup wizard is launched to guide you through the creation of the data target.

    When writing to an Excel spreadsheet you must first determine the structure of the data area to write into. We recommend that you use an existing spreadsheet to simplify this process.

    Clicking on 'Read structure from an existing sample document' button will run the Excel Reader Wizard to allow you to select the data range.

     

    If you chose to select the data range from an existing spreadsheet, this page will be pre-populated with the range information you specified.

    If not, you can manually specify the required range information.

    You can also specify the option to 'Write Column Names' into the output.

     

    The final screen allows you to specify the output filename to use.

     

     

    Once you press Finish the new Text Data target is added to the transform and can be used as any other data target is.

    Property Pages

     

    Name

    The name of the component, must be unique within the transform

     

     

    Edit Columns

    Allows the column definitions to be manually edited.

    Default output filename

    If the writer component does not have a connector to the 'Filename' input then the filename the data is written to is taken from this property.

    If the connection point 'Filename' is connected, then this property is ignored (and can be blank)

    Store as relative path

    Indicates that the filename is to be resolved relative to the data mapping file (.dm). If the transform is compiled the filename will be resolved relative to the compiled exe.

    Default Encoding

    The encoding used to write the text data to a file.

    Write column heading on first line

    If checked then all the column headings are written onto the first line of the file.

     

     

     

    Inputs

    The component has a root input called 'Filename', each value provided to this is treated as a filename and a new Excel document is created.

    If the 'Filename' input is not connected then the "Default target file" is used (see properties window).

    The child inputs are all specific to the Text standard you selected when the component was created.