MATLAB: How to import a text (.txt) file to MATLAB

doit4meexcelMATLABno attempttxt

how can i import a text (.txt) file that incloude several column and row whitout using Exel ??? i copy txt file to a new exel file and use : [numdata,txtdata]=xlsread('MyExelFile') to import it in MATLAB , and i want directly import this txt file to MATLAB without using Exel… Answer me…Thanks

Best Answer

.
Interactively:
I think the simplest way is to read the file interactively with "Import Data ..." in the File menu (R2012a).
.
Width code:
fid = fopen('cssm.txt', 'r' );
cac = textscan( fid, '%f%f%f%f%f%f', 'CollectOutput', true, 'Headerlines', 2 );
fclose( fid );
cac{:}
returns
ans =
1.0e-03 *
0 0 0 0 0 0
0 0 0 0 0 0
1.0000 0 1.0000 0 1.0000 0
1.0000 0 1.0000 0 1.0000 0
1.0000 0 1.0000 0 1.0000 0
where cssm.txt contains
XY
COP x COP y COP z
0 0 0 0 0 0
0 0 0 0 0 0
0.001 0 0.001 0 0.001 0
0.001 0 0.001 0 0.001 0
0.001 0 0.001 0 0.001 0
.
Including the header:
fid = fopen('cssm.txt', 'r' );
h1 = textscan( fid, '%s', 1 );
h2 = textscan( fid, '%s%s%s%s%s%s', 1, 'CollectOutput', true );
cac = textscan( fid, '%f%f%f%f%f%f', 'CollectOutput', true, 'Headerlines', 0 );
fclose( fid );
h1{:}
h2{:}
cac{:}
returns
ans =
'XY'
ans =
'COP' 'x' 'COP' 'y' 'COP' 'z'
ans =
1.0e-03 *
0 0 0 0 0 0
0 0 0 0 0 0
1.0000 0 1.0000 0 1.0000 0
1.0000 0 1.0000 0 1.0000 0
1.0000 0 1.0000 0 1.0000 0
.
Mimicing xlsread output
fid = fopen('forceplate_3.txt', 'r' );
h1 = fgetl( fid );
h2 = textscan( fid, '%s%s%s%s%s%s', 1, 'CollectOutput', true );
cac = textscan( fid, '%f%f%f%f%f%f', 'CollectOutput', true, 'Headerlines', 0 );
fclose( fid );
txtdata = repmat({''}, 2, 6 );
txtdata(1,1)= {h1};
txtdata(2,:)= h2{:};
numdata = cac{:};
the results are:
>> whos *data
Name Size Bytes Class Attributes
numdata 21000x6 1008000 double
txtdata 2x6 1382 cell