Excel Reader

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”

Ignore format option

• How to read a single excel cell value

Video Tutorial