If an Excel file has two rows of headers on a sheet, can the Excel Connector read the data?

Question

I have an Excel sheet with two rows of headers.
Is it possible to read this data with HULFT Square's Excel Connector?

Answer

HULFT Square can read data with Read from Sheet operation of the Excel Connector, even if the header has multiple rows.
In this case, you can read the data by specifying the read range in the Start/End condition tab or by using the Excel Read Wizard.

Also, by using Read from Named Range operation, it is possible to read different data formats, such as formats with varying numbers of headers or detail rows.

Try the above operations and check if you get the expected results.

Read from Sheet
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/excel_get_sheet_data.htm

Excel Read Wizard
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/excel_get_sheet_wizard.htm

Read from Named Range
https://www.hulft.com/help/en-us/HULFTSquare/Content/Designer/Connector/excel_get_area_data.htm