<< elimination Basic functions extraptab >>

Grocer >> Basic functions > expbd2exc

expbd2exc

exportation to Excel

CALLING SEQUENCE

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

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

* sepcol = the separartor used for colums (optional: if not given, then set to the char ' ')

* names = the names to give to the variables in the destination file if the user wants them to differ from their Scilab names (optional)

 

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

Report an issue
<< elimination Basic functions extraptab >>