您可以使用包gt
设置演示质量表的格式。
See 这个介绍gt.
这是代码,输出省略。
suppressPackageStartupMessages({
library(tidyverse)
library(gt)
})
data <- structure(list(
A = c("Date)", "Values"),
B = c("2023-04-03", "Heat Capacity\nSpecific Heat Capacity\nHeat Index" )),
row.names = c(NA, -2L), class = c("tbl_df", "tbl", "data.frame" ))
data %>%
mutate(B = gsub("\\n", "<br>", B)) %>%
gt() %>%
fmt_markdown(columns = everything())
Created on 2023-08-05 with reprex v2.0.2
Edit
您可以导出为 HTML 文件并在 Excel 中打开该文件:
data %>%
mutate(B = gsub("\\n", "<br>", B)) %>%
gt() %>%
fmt_markdown(columns = everything()) %>%
as_raw_html() %>%
writeLines(con = "~/Temp/so.html")