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”
Please make sure that the range names are not duplicated within the file
Ignore format option
Not all formats are supported
Last updated: August 1, 2022