Used to exchange data with MS Excel documents. Data are read/stored from/to the first line or all lines in the specified worksheet's range. Data exchange is made using a list of variables specified in the component. Variables in the list corresponds to columns on the worksheet, i.e. the first variable exchanges it's value with cells in the first column, the second - with cells in the second column etc.

Select Workbook

Set Excel workbook file name.

Worksheet

Set worksheet name, which is used to exchange data.

Action

Set the action and direction of data exchange. The following actions are possible:

Read Data Cells

Reading data from cells of the line found by the condition specified below. The extracted data are transferred into the variables specified in the component by the list. If the condition is not specified the first line of specified range will be read.

Append Data Cells

Appending data from variables into cells of the first empty line after the line found by the condition given below. If the condition is not specified the first empty line in the range will be used.

Replace Data Cells

Replacement of the data in cells of the line found by the condition specified below. The new data is taken from the variables given in the component by the list. If the condition is not specified, replacement will not be made and the component sets a failed state.

Replace or Append Data Cells

Data replacement or data addition into cells of the line found by the condition specified below. The new data is taken from the variables given in the component by the list. If the condition is not specified the first empty line in the range will be used.

Data Condition

Set an additional condition on a value in the specified column. Lines for which values in the specified below column does not meet condition, will be ignored.

Where

Set a name of the column for which condition will be used. The name of the column is taken from cells in the first line of the worksheet. I.e. name for the first column takes from cell A1, name for the second column from cell A2, etc.

Condition

Set the condition on value for the column specified in Where.

Range

Set an area in the worksheet for which lines to be read/stored in. By default the whole worksheet is used.

Data variables

Set the list of variables used for data exchange with cells of involved lines.

Combine Multiply Results

Enables the mode in which cells values of all lines from specified range for each column will be stored in the appropriate variable. A separator of values in the variable is carriage return. Only cells from lines which meet to the specified condition will be used.

---

Caching

The description of the Caching Tab see in the article Caching in components working with data servers.

Remarks

●To use this component, you must have Microsoft Excel installed on your computer.

●New line is not appended if the specified range does not contain an empty line. The component sets a failed state in this case.

See also

Processors

Database Access