[Scilab-users] scilab and xlsx - files

[Stéphane Mottelet]

Hi Philip,

The xlsreadwrite toolbox yields formatted dates in the string field. You should give it a try.

S.

> Le 5 nov. 2021 à 10:43, P M <p.muehlmann at gmail.com> a écrit :
> 
> 
> Dear,
> 
> thanks to the xls-link toolbox I am able to read data directly from an xlsx-file.
> 
> however, there is a strange data conversion going on:
> 
> in the xlsx-file a column contains time data such as:
> 
> 09:27:38    // this is a GMT value
> 
> result after reading the data into Scilab is like this
> 0,394189814814815
> 
> It is possible to get the hh:mm:ss back from this, like:
> 
> 0.394189814814815 * 24 =  9.4605556 --> 9   = hours value
> 0.4605556 * 60 = 27.63336                  --> 27 = minutes value
> 0.63336*60 = 38.0016                         --> 38 = seconds value
> 
> or:  
> 
> seconds = 0.394189814814815 * 24 * 60 * 60 ;
> date = getdate( seconds )                   
> - however
>   --> the date would be wrong
>        --> which is obvious, because the initial value does not indicate a specific day
> 
>   --> the time would have to be corrected for daylight saving time (summer time) if necessary
>        --> result is 10:27:38
> 
> My question is:
> Why is the extract from the xls file not intially in human readable format?
> Is it, because EXCEL internally stores the time value in a decimal fashioned way and only displays in human readable format?
> 
> Thank you,
> Philpp
> 
> 
> 
> _______________________________________________
> users mailing list
> users at lists.scilab.org
> http://lists.scilab.org/mailman/listinfo/users