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

[Adrien Vogt-Schilb]

hi

i'd avoid using xls_open, which i found not very reliable with large files.
i'd try to save the excel sheet as a tsv file (text separated by tabs), 
then read it from scilab with read_csv, then sparse myself the date 
strings with an ad hoc function

let me know if you find dificulties


On 17/11/2011 12:41, Petter Wingren wrote:
> 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?


-- 
Adrien Vogt-Schilb (Cired)
Tel: (+33) 1 43 94 *73 77*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.scilab.org/pipermail/users/attachments/20111117/06ab5c96/attachment.htm>