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

[Samuel Gougeon]

The whole example, with some slight improvements:

[fd, SST, Sheetnames, Sheetpos] = xls_open('file.xls');
[Value, trash] = xls_read(fd,Sheetpos);
mclose(fd);
d = getdate((Value(4:$,1)-25569)*24*3600);
d(:,9) = round(d(:,9)+d(:,10)/1000);
d = d(:,[6 2 1 7 8 9]);
datesText = msprintf("%02i/%02i/%04i %02i:%02i:%02i\n",d(:,:));

-->datesText
  datesText  =

!21/11/2010 20:43:00  !
!                     !
!21/11/2010 20:43:10  !
!                     !
!21/11/2010 20:43:20  !
!                     !
!21/11/2010 20:43:30  !
!                     !
!21/11/2010 20:43:40  !
!                     !
!21/11/2010 20:43:50  !
!                     !

...

Samuel