Reading an Excel file with mixed strings and numbers

Petter Wingren petterwr at gmail.com
Thu Nov 17 12:41:53 CET 2011


I am trying to read an excel file that looks somewhat like this (only
a lot bigger):

Download Time 19:54:08	
Download Date 11-21-2010	
--------------------------------------------------	
11/21/2010 19:43:30	0
11/21/2010 19:43:40	0
11/21/2010 19:43:50	0
11/21/2010 19:44:00	0
11/21/2010 19:44:10	0
11/21/2010 19:44:20	0
11/21/2010 19:44:30	518
11/21/2010 19:44:40	1139
11/21/2010 19:44:50	1035
11/21/2010 19:45:00	501
11/21/2010 19:45:10	449
11/21/2010 19:45:20	901
11/21/2010 19:45:30	545
11/21/2010 19:45:40	113
11/21/2010 19:45:50	1
11/21/2010 19:46:00	37
11/21/2010 19:46:10	17
11/21/2010 19:46:20	71


After I've read it I want to crop it according to a specific time and
keep the values in the second column.
However, when I do
[fd,SST,Sheetnames,Sheetpos] = xls_open('file.xls')
[Value,TextInd] = xls_read(fd,Sheetpos)

Value only contains *** in the first column, and TextInd mostly zeroes.

Any suggestions on how to get those timestamps?



More information about the users mailing list