There two transformation functions dedicated to working with Excel cells  "Get Excel cell value" and "Get Excel cell value dynamic".


Both of them work the same way: They open the excel file, get cell value, close excel file. This process is done for every source record. Let assume that the data source has 10000 records. It takes approximately two seconds to open the file. Out transformation has five  "Get Excel cell value"  transformation functions. It will take ten seconds to transform a single row an more than one hundred thousand seconds to process the entire data source.

Excel Transformation example

Improving performance

When possible "Get Excel cell value" and "Get Excel cell value dynamic" should be avoided. Otherwise, move "Get Excel cell value" and "Get Excel cell value dynamic" into separate Transformer (Transformer5) and read the data once. That will improve performance multiple times.

excel transformation example 2

Reading data once: double click on Reader 2 and set read first record/line to 1

Direct link, no registration required.

This site uses cookies. By continuing to browse the site, you are agreeing to our use of cookies