Cannot save tible with row.names = FALSE

[david-cortes]

Steps to reproduce:

• Create some data.frame with several columns.
• Convert said data.frame to tibble (which for example, happens implicitly when doing operations on it with dplyr).
• Try to save the object to an excel file without row names, e.g.

xlsx::write.xlsx(tibble_obj, "excel_file.xlsx", row.names = FALSE)

Expected behavior: should save the file normally.

Actual behavior: throws the following error:

Error in .jcall(cell, "V", "setCellValue", value) : 
  method setCellValue with signature ([D)V not found
In addition: Warning message:
In if (is.na(value)) { :
  the condition has length > 1 and only the first element will be used

But note that the following do not produce any error:

xlsx::write.xlsx(as.data.frame(tibble_obj), "excel_file.xlsx", row.names = FALSE)
xlsx::write.xlsx(tibble_obj, "excel_file.xlsx", row.names = TRUE)

Setup: xlsx 0.6.1, R 3.5.1, openjdk 11.0.2, running on windows 10.

[phineas-pta]

it's still relevant today: xlsx 0.6.5, R 4.2, openjdk 17, windows 11

[lillianhorin]

I received this error today as well, with the same solutions as in @david-cortes ' post.

[pablopalamarchuk]

Same here. %>% as.data.frame() %>% solve the issue. W11 R 4.2.3