File: excel2sci.sci

package info (click to toggle)
scilab 2.4-1
  • links: PTS
  • area: non-free
  • in suites: potato, slink
  • size: 55,196 kB
  • ctags: 38,019
  • sloc: ansic: 231,970; fortran: 148,976; tcl: 7,099; makefile: 4,585; sh: 2,978; csh: 154; cpp: 101; asm: 39; sed: 5
file content (34 lines) | stat: -rw-r--r-- 620 bytes parent folder | download 
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
29
30
31
32
33
34
 
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
[lhs,rhs]=argn(0)
if rhs<2 then sep=',',end

v=read(fname,-1,1,'(a)')
n=size(v,1)
mat=[]
for i=1:n
  line=v(i,:)
  ki=1
  row=[]
  ln=length(line)
  for k=1:ln
    if part(line,k)==sep then
      if k==ki then 
	row=[row,emptystr()]
      else
	row=[row,part(line,ki:k-1)]
      end
      ki=k+1
    end
  end
  k=ln
  if k==ki then 
    row=[row,emptystr()]
  else
    row=[row,part(line,ki:k-1)]
  end
  mat=[mat;row]
end