阻止writeDataTable (openxlsx)写入任何列名

Question

将表写入Excel工作簿时：

wb <- createWorkbook()
addWorksheet(wb, "Data")
data <- tibble(x = seq(1,10), y = c("A","B","C","D", NA, NA, NA, NA, NA, NA))
writeDataTable(wb, sheet = "Data", x = data, colNames = FALSE, withFilter = FALSE, tableStyle = "none")
saveWorkbook(wb, file = "Temp.xlsx", overwrite = TRUE)

即使在colNames = FALSE时，也会写入名称--只是实际的列名会被"Column1“、"Column2”等替换。

有没有一种方法可以让writeDataTable写入表并完全省略列名-这样data.frame中的第一个数据值就会写入A1 (或任何指定的位置)，而不是"Column1"？

Answer 1

事实证明，解决方案有点微不足道--使用writeData而不是writeDataTable。

wb <- createWorkbook()
addWorksheet(wb, "Data")
data <- tibble(x = seq(1,10), y = c("A","B","C","D", NA, NA, NA, NA, NA, NA))
writeData(wb, sheet = "Data", x = data, colNames = FALSE, withFilter = FALSE, tableStyle = "none")
saveWorkbook(wb, file = "Temp.xlsx", overwrite = TRUE)

我没有意识到writeDataTable函数是专门用来写Excel表的--和我想的相反(一般只是写数据表)。