Grocer Function

NAME

impexc2bd - importation of a csv excel file

CALLING SEQUENCE

impexc2bd(filein,sep,fileout)

PARAMETERS

Input

Output

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