Learn R Programming

openxlsx2 (version 0.7)

convertToExcelDate: convert back to ExcelDate

Description

convert back to ExcelDate

Usage

convertToExcelDate(df, date1904 = FALSE)

Arguments

df

dataframe

date1904

take different origin

Examples

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

Run the code above in your browser using DataLab