File: readxls.sci

package info (click to toggle)
scilab 4.0-12
  • links: PTS
  • area: non-free
  • in suites: etch, etch-m68k
  • size: 100,640 kB
  • ctags: 57,333
  • sloc: ansic: 377,889; fortran: 242,862; xml: 179,819; tcl: 42,062; sh: 10,593; ml: 9,441; makefile: 4,377; cpp: 1,354; java: 621; csh: 260; yacc: 247; perl: 130; lex: 126; asm: 72; lisp: 30
file content (23 lines) | stat: -rw-r--r-- 686 bytes parent folder | download | duplicates (2) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
function sheets=readxls(fil)
//Authors Pierrick Mode, Serge Steer INRIA, Copyright INRIA
  if argn(2)==1 then opt=1,end
  fil=pathconvert(fil,%f,%t)
  sheets=mlist(['xls','sheets'],list())
  [fd,Text,Sheetnames,Abspos]=xls_open(fil)
  Text=['', Text];
  for k=1:size(Abspos,'*')
    [Value,TextInd]=xls_read(fd,Abspos(k))
    if Value==[] then
      sheet=mlist(['xlssheet','name','text','value'],Sheetnames(k),[],Value)
    else
      if size(Text,'*')==1 then
	T=emptystr(Value)
      else
	T=matrix(Text(TextInd+1),size(Value))
      end
      sheet=mlist(['xlssheet','name','text','value'],Sheetnames(k),T,Value)
    end
    sheets.sheets($+1)= sheet
  end
  mclose(fd)
endfunction