File Wizard: Type - Excel XLSX

Tables In the Tables group it is possible to choose a specific table when reading from a file containing several tables, e.g. HTML or Excel files. In Excel, all sheets in a workbook and all named areas (e.g. multiple cells with names) in the worksheets are identified as possible tables. Note that the Excel sheet names must not contain the characters &, > or <.
When defining a named area on a sheet, the selected Scope must be Workbook and the Refers to field must keep its original value (the one assigned by default). Otherwise, the named area might not be seen as a table.
Header Size Here it is possible to omit the header part of the file: a specified number of lines or bytes (only for delimited, fixed record and Excel files).
Labels If the field names (column headers) are stored in the first line of the table, this control should be set to Embedded. The DIF format also allows field names to be explicitly specified, and if that is the case, this control should be set to Explicit. If the table contains no field names, the None alternative should be used.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?