<< elimination Basic functions extraptab >>

Grocer >> Basic functions > expbd2exc

expbd2exc

exportation to Excel

CALLING SEQUENCE

[]=expbd2exc(bd,out,sep,transpose)

PARAMETERS

Input

• bd = the name of a database or of a list of ts loaded in the environment

• out = the excel file where to save the data

• sep = decimal separator (optional: if not given then sep= '.')

• transpose=anything, but optional: if given then series are exported in rows instead of columns

Output

• nothing

DESCRIPTION

Exports the content of a data base or a list of variables bd to a file that Excel can read

EXAMPLE

expbd2exc(GROCERDIR+'data/bdhenderic.dat','c:/mydb/mydata.txt')
// save on a file 'c:/mydb/mydata.txt' the variables 'rnet','ly', 'lp' and 'lm1' contained in the scilab file GROCERDIR+'data/bdhenderic.dat'

load(GROCERDIR+'data/bdhenderic.dat');
expbd2exc(list('rnet','ly', 'lp','lm1'), 'c:/mydb/mydata.txt')
// same thing as previous example

expbd2exc(GROCERDIR+'data/bdhenderic.dat','c:/mydb/mydata.txt',',','transp')
//same thing as previous example, expect that decimal sperator is ',' instead of '.' and series are exported in columns and not in rows

AUTHOR

Eric Dubois 2002

<< elimination Basic functions extraptab >>