r语言 - 将df转换为ics时,Output不做任何操作



我有一个这样的样式的df:

structure(list(`DTEND;VALUE=DATE` = structure(c(19389, 19395, 
19396, 19402, 19409, 19410), class = "Date"), `DTSTART;VALUE=DATE` = structure(c(19389, 
19395, 19396, 19402, 19409, 19410), class = "Date"), SUMMARY = c("Activity", 
"Activity", "Activity", 
"Activity", "Activity", 
"Activity"), UID = c("beb9cbab6d0a2534d17c", 
"0f57d3b22bd2b6ed4950", "c3f192b290e8f001529c", "c15769cc203dfbe8caa6", 
"d3554e447336aa78ddd8", "e78a4cfd97307bdb2ea5"), SEQUENCE = c("0", 
"0", "0", "0", "0", "0"), DTSTAMP = c("20230116T175008Z", "20230116T175008Z", 
"20230116T175008Z", "20230116T175008Z", "20230116T175008Z", "20230116T175008Z"
), DESCRIPTION = c("link to open", 
"to open", 
"link to open", 
"link to open", 
"link to open", 
"link to open"
), LOCATION = c("M", "M", "M", 
"M", "M", "M"
)), row.names = c(NA, -6L), class = c("tbl_df", "tbl", "data.frame"
))

我正在尝试使用库(日历)将此数据帧转换为可用的ics格式。虽然下面的代码在我的计算机上生成了一个ics文件,但在试图将其导出到outlook(或直接打开它)时,它没有做任何事情:

ic_write(df, MY-DESKTOP-LOCATION)

使用这里找到的指导:https://www.rdocumentation.org/packages/calendar/versions/0.0.1下载示例文件(在页面顶部找到),使用函数ic_read()将其转换为另一个df,然后再次使用ic_write()对该示例文件有效。有人知道为什么我的df(上面的输出)没有按预期运行吗?(发布的事件意味着全天的事件)。

我设法使它工作,首先通过将日期列的名称更改为DTSTART和DTEND,然后使用as.POSIXct()将它们转换为POSIXCT。然后我使用ical()转换df,然后使用ic_write()编写相应的ical文件来修复它。

最新更新