savetoexcel: Save zsl Result to the Excel File

In baixueyuan/zsl: Download and manipulate discount rate of bond from China Clear.

Description

Save the data to Excel file which is generated by zslTwoDayDiff and other functions giving the comparison result.

Usage

zslSaveToExcel(data, output.file = "zsl.xlsx", assign = FALSE)

zslSaveToExcelP(data, wb, output.file = "zsl.xlsx")

Arguments

data	the data to be saved to Excel file.
output.file	the file path of the ouput, if missed, it is set to "zsl.xlsx" in the working directory.
assign	logical, default is FALSE, if TRUE, the workbook object generated by XLConnect package will be assigned to the Global environment, named "wb".
wb	the workbook object, used in zslSaveToExcel to add worksheet, it can be missed and generate a new Excel file with template.

Details

For the convenience of viewing the result, the function changed somewhere to Chinese, including the "mark" column and the column names.

The funcion uses XLConnect package to manipulate the Excel file. For the format, the style action is set to "NAME_PREFIX" and the style is already adjusted well in the "template.xlsx".

Besides, using param assign can assign the workbook object to the Global environment. This is uesful for generating multiple sheets Excel file.

The function zslSaveToExcelP saves the data returned by zslPeriodDiff.

Value

No obvious return, the data will be saved to Excel file.

baixueyuan/zsl documentation built on May 11, 2019, 5:27 p.m.