exportation to Excel
[]=expbd2exc(bd,out,sep,transpose,sepcol,names)
* 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)
* nothing
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 | ![]() | ![]() |