Issue in write_xlsx? about writexl HOT 7 CLOSED

Can reproduce this on colleagues computer (same machine, only 16gig of RAM)

Can't replicate it on home PC (windows 10, far less spec'd).

Closing issue.

from writexl.

I just got the error message when passing a list of dataframes into writexl::write_xlsx.
One of my list elements had a lengthy name (e.g., the name I wanted to assign to the tab on the resultant .xlsx file. By shortening the name from 35 characters, the function worked without error. I imagine this is a limit imposed by Excel.

from writexl.

I'm running into a similar issue with trying to write 27 xlsx files in a for loop. 24 of them write just fine. Another worked when I ran it manually, and the others didn't work until I changed the write directory.

from writexl.

@gfleetwood what error did you get? Are you also using very long file names or is it another issue?

from writexl.

@jeroen No error. It just didn't write to the folder. The file names are relatively long (plus I'm passing a full path) and are constructed using glue. But all the file names are basically the same length so it's not clear why it would work for most and not for a few.

Here's an example of my write process:

path = "~/../Downloads/FOLDER/FOLDER/2020-04-13_abcdefgh.xlsx"
sheet_name = "April"
df_list <- setNames(list(df), sheet_name)
write_xlsx(df_list, glue(path), format_headers = FALSE)

from writexl.

@gfleetwood, just curious if you're on Windows? If so, does the total folder+file path exceed 255 6 characters? That's the default limit in Windows ....

https://stackoverflow.com/a/265782/2449656

from writexl.

@KyleHaynes I'm on Windows but it's not a problem in this case. The longest path is 190 characters. It happens to be one of the three that aren't working. The other two are 161 and 164 chars, but numerous files worked whose path were 161/163 chars.

from writexl.