[scilab-Users] Reading an Excel file with mixed strings and numbers

[Petter Wingren]

On Thu, Nov 17, 2011 at 8:04 PM, Samuel Gougeon <sgougeon at free.fr> wrote:
> Hello,
> Could you post on the mailing list a xls sample extracted among your files?
> Without such an example, it is difficult to help.
> Regards
> Samuel

What I inserted in the first mail is a cut'n'paste sample, Down to the
"------------------------------" its all text in one column.
Below that, it's two columns (timestamp in the first and the number to
the right in the second).

I attached the sample as an .xls file here too if that helps.

/Petter


> Le 17/11/2011 12:41, Petter Wingren a écrit :
>>
>> 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?
>>
>>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: blue101121sample.xls
Type: application/vnd.ms-excel
Size: 10240 bytes
Desc: not available
URL: <https://lists.scilab.org/pipermail/users/attachments/20111118/319c415a/attachment.xls>