Extracting data from Excel sheets, tables and ranges

Advanced ETL Processor - 6.4.3.0 is ready for the users.

A new version of Advanced ETL Processor with extended support for Excel:

• Add support for extracting data from Excel Tables
• Added support for creating and updating Excel Tables

Transformation example

About Excel Tables:

An Excel table is a collection of data organized in rows and columns, formatted as a table to manage and analyze data efficiently. Tables are used to make data management easier, enabling features like sorting, filtering, and structured references.

Features:

1. Automatic Formatting: When you convert a range of data into a table, Excel automatically applies a specific style.
2. Headers: Tables typically include headers in the first row.
3. Sorting and Filtering: Tables come with built-in options to sort and filter data easily.
4. Structured References: Tables allow you to use structured references in formulas, which makes it easier to refer to specific columns and rows.
5. Auto-expanding: Tables can automatically expand to include new rows or columns added to the data range.

Viewing list of Excel tables and ranges: