<< ptrend Basic functions repmat >>

Grocer >> Basic functions > readxls2bd

readxls2bd

importation of an excel file

CALLING SEQUENCE

readxls2bd(filein,sep,fileout,arg1,...,argn)

PARAMETERS

Input

* filein = name of the file to be imported (between quotes)

* fileout = name of the scilab file where to save the imported data (between quotes)

* argi = optional arguments

  - 'namedat = xxx' where xxx is the name given to the field dates in the .csv file (default: dates)

  - 'sheetsnum = x1;x2;...;xn' where the xi's are the s of the sheets to import

  - 'prefix = xxx' where xxx is the prefix that will be added to the names of the variables in the .csv database to obtain their names in the Scilab .dat database

  - 'namedat = xxx' where xxx is the name given to the field dates in the .csv file (default: dates)

  - 'namena = x1;x2;...xn' where xi are the values that the Non Available data can take in the .csv file ('default: ' ' and '#N/A')

  - 'prefix = xxx' where xxx is the prefix that will be added to the names of the variables in the .csv database to obtain their names in the Scilab .dat database

 

Output

Nothing: the imported series are saved in the file named fileout

DESCRIPTION

Imports an excel file provided it is in the BIFF8 Excel files (last Excel versions). This is a function derived from the Scilab readxls function, extended to associate values to variables and to deal with ts. NOTE: the function works only with the last Excel versions and, even in that case, does not in some cases (data determined by formulas for instance). If you do not manage to import your database with read2xls2bd, then try impexc2bc.

EXAMPLE

readxls2bd(GROCERDIR+'/data/bdhenderic.xls','mylibrary/bdhenderic.dat')
// provides the importation of data in file GROCERDIR+'/data/bdhenderic.xls into the Scilab file mylibrary/bdhenderic.dat.

AUTHOR

Eric Dubois 2007

Report an issue
<< ptrend Basic functions repmat >>