Description Usage Arguments Details Value Examples
Creates a cell for a date.
1 2 3 |
col |
integer, the column index |
row |
integer, the row index |
date |
an input which will be parsed to a date through the
|
colspan |
integer, number of columns the cell spans |
rowspan |
integer, number of rows the cell spans |
comment |
cell comment, character |
commentAuthor |
author of the comment, character |
fontname |
font name; see |
bold |
set |
color |
color name; see |
fill |
color name; see |
dateFormat |
the date format |
... |
arguments passed to |
A date in Excel is stored as an integer: the number of days between
this date and a certain origin. The cellDate
function calculates this
integer and then passes it to the function cell
with a date format.
A named list representing a cell.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | A1 <- cellDate(1, 1, "2017-06-14")
unlist(A1)
A1 <- cellDate(1, 1, as.Date(42900, origin="1899-12-30"))
unlist(A1)
A1 <- cellDate(1, 1, "2017/06/14")
unlist(A1)
A1 <- cellDate(1, 1, "20170614")
unlist(A1)
A1 <- cellDate(1, 1, "06-14-2017")
unlist(A1)
A1 <- cellDate(1, 1, "2017-06-14 04:05:06")
unlist(A1)
A1 <- cellDate(1, 1, "2017-06-14 04:05:06", tz="America/Los_Angeles")
unlist(A1)
A1 <- cellDate(1, 1, Sys.Date())
unlist(A1)
A1 <- cellDate(1, 1, "x")
unlist(A1)
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.