openxlsx2 (version 0.7.1)

convertToExcelDate: convert back to ExcelDate

Description

convert back to ExcelDate

Usage

convertToExcelDate(df, date1904 = FALSE)

Arguments

df

dataframe

date1904

take different origin

Examples

 xlsxFile <- system.file("extdata", "openxlsx2_example.xlsx", package = "openxlsx2")
 wb1 <- wb_load(xlsxFile)
 df <- wb_to_df(wb1)
 # conversion is done on dataframes only
 convertToExcelDate(df = df["Var5"], date1904 = FALSE)