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”

Data Source is an Excel File

Excel Data Range

Ignore format option

Ignore format option

Video Tutorial

Last updated: August 1, 2022