Name

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


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