Data Source is an Excel File

Data can be extracted from the entire Sheet or just from the data range.

Advanced ETL Processor assumes that “Sheet name” and “Range name” are delimited by colon (:).

Users can still call Sheets as a “Great.Victory”

The logic as follows:

• Advanced ETL Processor checks if Great.Victory sheet exits then it will read it
• If it does not exists it will check if Great sheet exits
• If it does exists it will check if Victory range exists if it does It will read data from just Victory range
• If it does not it will read the data from Sheet “Great”

Note: Please make sure that the range names are not duplicated within the file

Ignore format option:

Not all formats are supported

How to read a single excel cell value