MATLAB: Is it possible to choose the column headers row in Import Wizard

colheadersheaderimportMATLABtextdatawizard

When importing an XLS file using Import Wizard, "colheaders" is created from the row of text that is immediately above the numeric data . Currently, there is no possibility to choose another row. This makes it difficult to import a file if there is additional text between the column headers and the numeric data (see attached file test.xls).

Best Answer

The ability to choose the column header row from the Import Wizard is not present in MATLAB.
To work around this issue, you will need to create a custom function to parse the raw data after importing it into the MATLAB Workspace.