Error in libxlsxwriter: 'String exceeds Excel's limit of 32,767 characters.' about writexl HOT 5 CLOSED

writexl is behaving as expected here, it gives you an error when the string cannot be converted.

It is up to you to prepare the data so that it can be written to excel. You could use nchar() on the columns and either truncate or replace the cells that are too big. It would be dangerous if writexl would do this because it leads to data loss.

from writexl.

Can you please include example code?

from writexl.

library(writexl)

c0 <- c(strrep("a",1),"b")
c1 <- c(strrep("a",32767),"b")
c2 <- c(strrep("a",32768),"b")

data1 <- c()
data2 <- c()

data1$V1 <- as.data.frame(c0)
data1$V2 <- as.data.frame(c1)

data2$V1 <- as.data.frame(c0)
data2$V2 <- as.data.frame(c2)

data1 <- as.data.frame(data1)
data2 <- as.data.frame(data2)

write_xlsx(list("sheet1"=data1, "sheet2"=data2),
path = "output.xlsx", col_names = TRUE, format_headers = TRUE)

Error: Error in libxlsxwriter: 'String exceeds Excel's limit of 32,767 characters.'

Here is the example code. thanks.

from writexl.

Can you please include example code?

I used for-loop to analyze hundreds of dataframes. Most of them output normally, however, a few might encounter the error, and will lead the stop of the program. If there is a paramater to avoid the termination, it will be helpfull.

from writexl.

@jeroen could you please help to explain more? What do you do with nchar() before using writexl to export data frame into excel file?

from writexl.