Quite often it is necessary to get the content of an Excel cell and load it into the database. For example, when processing invoices it would be necessary to load an invoice date.

In the latest version of Advanced ETL Processor, we have introduced Get Excel Cell Value transformation function

GetExcelCellValue

There is also the dynamic version of this function:

Get Excel Cell Value Dynamic

See it yourself, Download Advanced ETL Processor Enterprise Now!

We have 275 guests and no members online