Grocer Function
NAME
impexc2bd - importation of a csv excel file
CALLING SEQUENCE
impexc2bd(filein,sep,fileout)
PARAMETERS
Input
-
filein = name of the file to be imported (between quotes)
-
sep = separator used in the filein (between quotes)
-
fileout = name of the scilab file where to save the imported data (between quotes)
Output
- Nothing: the imported series are saved in the file named fileout
DESCRIPTION
Imports an excel file saved under csv format: this is at the very beginning an original scilab function, but improved to be more efficient and extended to deal with ts.
If one data is named dates or DATES (scilab distinguish capitals from small letters) then the following data are saved as timeseries.
If a value is lacking or #N/A in a timeseries, it is given a NA value.
EXAMPLE
impexcel('macros/bdexamples/bdhenderic.csv',';','mylibrary/bdhenderic.dat')
This example provides the importation of date in file macros/bdexamples/bdhenderic.csv into the Scilab file mylibrary/bdhenderic.dat. The separator is here ' ;'.
AUTHOR
Eric Dubois 2002