"..." not transferring to writeData(Table) #151
Description
Stemming from https://stackoverflow.com/q/66785955/3358272, it appears that (at least) withFilter= and colWidths= are not being passed through write.xlsx to writeData or writeDataTable:
write.xlsx(mtcars, "mt.xlsx", asTable=TRUE, row.names=FALSE,
firstActiveRow=2, colWidths="auto", withFilter=FALSE)
write.xlsx(mtcars, "mt.xlsx", asTable=TRUE, row.names=FALSE,
firstActiveRow=2, colWidths="auto", withFilter=TRUE)both produce the same table:
But doing it manually works:
wb <- createWorkbook()
addWorksheet(wb, "mtcars")
writeDataTable(wb, "mtcars", mtcars, withFilter=FALSE)
saveWorkbook(wb, "mt.xlsx")