File: excel2sci.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 (28 lines) | stat: -rw-r--r-- 636 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
24
25
26
27
28
 
function mat=excel2sci(fname,sep)
// Given an ascii  file created by Excel using "Text and comma" format
// exel2sci(fname) returns the corresponding Scilab matrix of strings.
// Copyright INRIA

if argn(2)<2 then sep=',',end
v=mgetl(fname);
ns=length(sep);
mat=[];ki=1;
for i=1:size(v,'*')
  line=v(i)
  K=[strindex(line,sep)];
  ki=1;row=[];
  for k=K
    row=[row,part(line,ki:k-1)];
    ki=k+ns;
  end
  row=[row,part(line,ki:length(line))]
  if i>1 then
    if size(row,2)>size(mat,2) then
      mat($,size(row,2))=''
    elseif size(row,2)<size(mat,2) then
      row(size(mat,2))=''
    end
  end
  mat=[mat;row];
end
endfunction