<< expbd2exc Basic functions extraptab >>
Grocer >> Basic functions > expbd2xls

expbd2xls

Exports to an Excel file

CALLING SEQUENCE

expbd2xls(bd,output,transpose,names,sheetname)

PARAMETERS

Input

* bd = a string, the name of a database or a string vector, the names of variables loaded in the environment

* output = the excel file where to save the data

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

* transpose = a boolean indicating whether the data must be transposed or not (default = %f)

* names = (k x 1) string vectors, the names that the variables will have in the csv files (optional; default: the names of the data in Scilab)

Output

nothing

DESCRIPTION

Exports the content of a data base or a list of variables bd to a xls or xlxs Excel file.

EXAMPLE

global GROCERDIR;
// export data form the Hendry and Ericsson databse in the sheet data of
// file bdhenderic.xls in the floder tmp of GROCER distribution
expbd2xls(GROCERDIR+'\data\bdhenderic.dat',GROCERDIR+'\tmp\bdhenderic.xls','data') 

load(GROCERDIR+'\data\bdhenderic.dat')
expbd2xls(['lm1','lp','ly','rnet','const','trend'],GROCERDIR+'\tmp\bdhenderic.xls','data2',%t,['log(m1)','log(p)','log(y)','rnet','constant','trend'])

AUTHOR

Éric Dubois 2021

Report an issue
<< expbd2exc Basic functions extraptab >>