text or datetime in the first column, cause the column indices of num and txt not to line up. This is the only function able to read numbers and text from a text file. sheet_namestr, int, list, or None, default 0. This syntax is supported only on Windows computers with Microsoft Excel software installed. Rename Excel column heading to MATLAB - MathWorks reading multiple sheets from excel to matlab - Stack Overflow It would, though, allow for the possibility of fopen() the file, fgetl() one line, fclose(), split the input line to get the column headers, then csvread() the file telling it to skip the first row. By file-like object, we refer to objects with a read () method, such as a file handle (e.g. Rename Excel column heading to MATLAB. Read cell array from file - MATLAB readcell - MathWorks How I can read a CSV file with header? - MathWorks how to import csv file in matlab - MathWorks example. With the Import tool open you can select data by left clicking and dragging the data that you want. use this code to convert the dates to MATLAB dates. Alternatively, you can specify the number of lines to skip using: T = readtable ('myfile.csv','NumHeaderLines',3); % skips the first three rows of data. How can I load .tab file with header in MATLAB raw, output argument. xlsread (MATLAB Functions) Alternatively, if you want to stick with fscanf you can check the first line of the file with fgetl and use frewind, if necessary (because fgetl moves the file pointer), to go back to the beginning of the file if there is no header. num = xlsread ('filename') returns numeric data in double array num from the first sheet in the Microsoft Excel spreadsheet file named filename. [~,~,dat]=xlsread ('filename.xls'); Description. To examine the resulting file, read the table back into the workspace by using the readtable function. Results may differ based on your system settings. Seems like the xlsread function only accepts Excel cell notation ('A1:B5') as input.