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