Extracting values from an excel sheet using textscan

Question

yashvin 2015-6-23

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/224955-extracting-values-from-an-excel-sheet-using-textscan

编辑： Stephen23 2015-6-23

actual_tgw2639true.csv

Hi I want to extract the values of latitude and longitude and store it in array. Please find below my code and my excel sheet

 fid  = fopen('actual_tgw2639true.csv');
Data = textscan(fid, '%s%f%f%f%*[^\n]', 'Headerlines', 1, 'Delimiter', ',');
fclose(fid);
Latitude=Data{3}';
Longitude=Data{4}';

Can i please know what is wrong?

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Jim O'Doherty 2015-6-23

在 MATLAB Online 中打开

Hi, I managed to get this to read in as strings rather than floats. And not using the \n modifier

Data = textscan(fid, '%s%s%s%s', 'Headerlines', 1, 'Delimiter', ',');

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Stephen23 2015-6-23

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/224955-extracting-values-from-an-excel-sheet-using-textscan#answer_183665

编辑：Stephen23 2015-6-23

在 MATLAB Online 中打开

actual_tgw2639true.csv

textscan works okay on that sample file. If you are having problems perhaps there is something in the real data file that does not match this format?

fid = fopen('actual_tgw2639true.csv','rt');
C = textscan(fid,'%s%f%f%f', 'Delimiter',',', 'HeaderLines',1);
fclose(fid);

which reads the dates as strings, and the rest of the data as floating point:

>> latitude = C{3}
latitude =
6600
9106
2050
9828
5950
5167
7567
5033
1817
4983
3567
1450
7250
3000
1667
9800
7367
6150
5222
>> longitude = C{4}
longitude =
5567
1264
5300
1714
9967
4167
9767
4917
5850
5300
9567
2200
7383
0050
0867
4350
8917
1200
1811

The date can be converted to a matrix of date vectors using datevec (and similarly to serial date numbers using datenum):

>> datevec(C{1},'dd/mm/yyyy HH:MM')
ans =
        2015           2           5          18          57           0
        2015           2           5          19          28           0
        2015           2           5          19          40           0
        2015           2           5          20           3           0
        2015           2           5          20          10           0
        2015           2           5          20          31           0
        2015           2           5          20          44           0
        2015           2           5          20          49           0
        2015           2           5          20          58           0
        2015           2           5          21          19           0
        2015           2           5          21          33           0
        2015           2           5          21          36           0
        2015           2           5          21          41           0
        2015           2           5          21          45           0
        2015           2           5          21          47           0
        2015           2           5          21          50           0
        2015           2           5          21          54           0
        2015           2           5          21          56           0
        2015           2           5          21          57           0