How can I load .tab file with header in MATLAB ?

There is excel file in .tab format of size approximately 300MB, opening in excel using delimited data type after pressing next giving option of all delimiters and column data format as a general.Now data comes in excel sheet,now want to load this file in matlab, this also having headers & I also want to load .tab directly in MATLAB, How can I?

Answer 1

[Walter Roberson]

xlsread() to read from the excel sheet.

textscan() with 'Delimiter', '\t' to read from the .tab directly.

[RS]

 Header and data are like this after opening in excel sheet, how can I load in MATLAB 

#  Header            
#  Header            
#  Header            
#  1  2  AQ           A  B    C  
27-Aug-09  00:00.1    2455070.583  766   1.01016  -0.89874

[Walter Roberson]

Adapting an example from the online documentation for xlsread:

filename = 'myExample.xlsx';
sheet = 1;
header_xlRange = 'A:D';

[headers_nums, header_text] = xlsread(filename, sheet, header_xlRange);

body_xlRange = 'E:';   %I am not certain about this

body_nums = xlsread(filename, sheet, body_xlRange);

[RS]

1. ok but if I want to read a particular column not by whole column as A to D, suppose I want to read only A and C, so how can I read 2. Suppose there is date and time data in a particular column that is also creating problem so how can I read.

[RS]

How can I input several column which are not in a sequence like A:D.