dateRefill.fromFileToExcel: Complete the hollow dataset
In Willdata/tigerhitteR: Pre-Process of Time Series Data Set in R

Description Usage Arguments Details Author(s) Examples

Take time series dataset and fields, then refill the missing date records and other fields.

1 2	dateRefill.fromFileToExcel(inPath, sheet, dateCol.index, outPath, fixedCol.index, uninterpolatedCol.index, uninterpolatedCol.newValue)

`inPath`	A path which is the location of uncompleted dataset which must be xlsx file
`sheet`	A worksheet name of the dataset
`dateCol.index`	Date column
`outPath`	A path where the location of xlsx file of completed dataset should be
`fixedCol.index`	A row of column number which should be kept same values with the original
`uninterpolatedCol.index`	The column number which should be changed to different value into new record.
`uninterpolatedCol.newValue`	The value of a specific column which should be put into the new record.

Real time series sales dataset could be not continuous in 'date' field. e.g., monthly sales data is continuous, but discrete in daily data.

This hollow dataset is not complete for time series analysis. Function dateRefill.fromFile is a transformation which tranforms uncomplete dataset into complete dataset.

Will Kuan