Excel

Incoming / Outgoing Excel

The Excel Transports must be routed to and from.  E.g. Excel files are received via Email, FTP, etc and then routed to the Excel transport for further processing.

Crossfire supports both xlsx and xls formats. 

Transport Options

Data Source: Required for outbound only.   This is the temporary path where the file is saved to before it is sent.   

Table Name: This is the name of the WorkSheet within the Excel file which is to be written to or read from. 

You can also specify excel range names in here using the following format: “SheetName$A1:C99”

This allows you to specify the area on the worksheet to be read. Otherwise excel will automatically establish the bounds of the worksheet using the data which has been entered.

The transport options for importing files.

• • "*" in the Table Name field will import the first sheet - hidden or otherwise

  • "Active" in the Table Name field will import the active sheet. This is the same sheet that will be shown by default when opening the XML or XLSX file in MS Excel

  • "[sheetname]" in the Table name field will try to find the sheet named and process it.

Create New Table (Outbound Only): If the WorkSheet specified in the Table Name field does not exist, it will create a new WorkSheet with this name.

Notes

When Crossfire reads Excel cells, if they contain a function (e.g VLOOKUP), then it will try to evaluate that function and use the result of the function as the value it reads.   If the function cannot be run (e.g. the VLOOKUP value doesn't exist) then it will use the text which is in the cell, which is typically the function text.