Advanced-etl-processor
Get Excel Cell Value Dynamic
| Key | Value |
|---|---|
| Category | Transformation Function |
| Description | Extracts Cell value from an excel file |
| Properties |
In most cases, “Cache values” must be checked. When “Cache values” is checked function opens and closes the Excel file for every source record, It takes time to open the file and get the cell value.
Here is another way of reading excel cell:
How to read a single excel cell value
Back to Working with Transformer
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum