Excel Read Header
ExcelReadHeader reads the column names of a sheet in an Excel spreadsheet file.
The column names are taken from the first row of the sheet. The function returns them as a list of text values, in the order in which the columns appear in the sheet.
Use this function together with ExcelReadBulk when the columns of the spreadsheet are not known at design time: ExcelReadHeader tells you which columns are present, and ExcelReadBulk iterates over the data rows.
Properties
Section titled “Properties ”File path
Section titled “File path ”The file path of the Excel file to read.
Sheet
Section titled “Sheet ”The name of the sheet to read, or \n to read the n’th sheet (1-based), e.g. \2 reads the second sheet in the workbook.
If not specified, the first sheet in the spreadsheet is read.
An exception is thrown if the specified sheet name does not exist in the workbook, or if the specified sheet number is out of range.
Result
Section titled “Result ”A list of text values containing the column names of the sheet.