Grocer Function
NAME
expbd2exc - exportation to Excel
CALLING SEQUENCE
[]=expbd2exc(grocer_bd,grocer_output,sep,transpose)
Input
-
grocer_bd = the name of a database or of a list of ts loaded in the environment
-
grocer_output = 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
1) expbd2exc('macros/grocer/bdexamples/bdhenderic.dat','c:/mydb/mydata.txt')
2) load('macros/grocer/bdexamples/bdhenderic.dat'); expbd2exc(list('cte','rnet','ly', 'lp','lm1'), 'c:/mydb/mydata.txt')
3) expbd2exc('macros/grocer/bdexamples/bdhenderic.dat','c:/mydb/mydata.txt',',','toto')
Examples 1 and 2 do exactly the same thing: save on a file 'c:/mydb/mydata.txt' the variables 'cte','rnet','ly', 'lp' and 'lm1' contained in the scilab file 'macros/grocer/bdexamples/bdhenderic.dat'.
Example 3 exports the same database, but:
a) decimal sperator is ',' instead of '.'
b) series are exported in columns and not in rows
AUTHOR
Eric Dubois 2002