How can I specify if I want to import header and detail data from an Excel sheet? – HULFT Square

Question

I have an Excel sheet that is formatted with a separate header and detail section.
If I want to read the header and detail data of each, how can I specify it?

Answer

The Excel connector has the Read from Named Range operation.

By assigning names to the header and detail sections in Excel, and by specifying each name as the read range in this connector, you can read the header and detail sections separately. Therefore, even different data formats such as headers and details can be read with this operation.

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