您可以使用
XLSREAD来完成此操作.首先将上面的示例数据放入文件“input_file.csv”中,以下是从
XLSREAD的三个输出中获取文件中的数值,文本值和原始数据的示例:
>> [numData,textData,rawData] = xlsread('input_file.csv')
numData = %# An array of the numeric values from the file
51.9358 4.1833
51.9354 4.1841
51.9352 4.1846
51.9343 4.1864
51.9343 4.1864
51.9341 4.1869
textData = %# A cell array of strings for the text values from the file
'ABC'
'ABC'
'ABC'
'ABC'
'ABC'
'ABC'
rawData = %# All the data from the file (numeric and text) in a cell array
'ABC' [51.9358] [4.1833]
'ABC' [51.9354] [4.1841]
'ABC' [51.9352] [4.1846]
'ABC' [51.9343] [4.1864]
'ABC' [51.9343] [4.1864]
'ABC' [51.9341] [4.1869]
然后,您可以对数字数据执行所需的任何处理,然后使用XLSWRITE将数据行的一部分重新保存到新文件.以下是一个示例:
index = sqrt(sum(numData.^2,2)) >= 50; %# Find the rows where the point is
%# at a distance of 50 or greater
%# from the origin
xlswrite('output_file.csv',rawData(index,:)); %# Write those rows to a new file