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