Issue with read_xlsx/write_xlsx in R

Asked Aug 06 '23 at 18:40

Active Aug 06 '23 at 20:07

Viewed 43 times

I have a simple Excel file available for download here. The file contains two columns, but when I read the file and subsequently write it back to an .xlsx format, certain properties, especially the newline property in some rows, are lost.

Example Excel file:

I read the excel file using read_xlsx :

library(readxl)
library(writexl)
df <- read_xlsx("./Excel Files/Test.xlsx", sheet = 1)

In the end if I write the xlsx:

write_xlsx(df,"Test2.xlsx")

Output of write xlsx:

Thank you for the help

edited Aug 06 '23 at 20:07

asked Aug 06 '23 at 18:40

Golem

Is that `writexl::write_xlsx`? Using `writexl::write_xlsx(readxl::read_xlsx("Test.xlsx"), "Test2.xlsx")`, when I open the resulting `Test2.xlsx`, there is a newline in cell `B3`. – r2evans Aug 06 '23 at 20:03
Yes `writexl`. Can you show your example. I tried your code but didn't work for me – Golem Aug 06 '23 at 20:07
Sure, https://i.stack.imgur.com/RfgEi.png – r2evans Aug 06 '23 at 20:09
1

For the record, I'm on linux, R-4.2.3, `readxl_1.4.2` and `writexl_1.4.2`. – r2evans Aug 06 '23 at 20:10
I tried different read and write package like `xlsx` but still the same result – Golem Aug 06 '23 at 20:13
my package version `readxl 1.4.3` and `writexl 1.4.2` – Golem Aug 06 '23 at 20:15
isn't this the same question as your earlier question Golem? – Mark Aug 07 '23 at 02:08
I tried to improve the previous question. By pointing where the problem really starts rather than the dput of dataframe in the previous question – Golem Aug 07 '23 at 11:09
if it's literally the exact same problem, then I'd delete one of the questions, probably the earlier one – Mark Aug 07 '23 at 11:29
@Mark Can't delete it – Golem Aug 07 '23 at 12:27
@Mark Can you close the old question and open this one up – Golem Aug 08 '23 at 15:15

Issue with read_xlsx/write_xlsx in R

0 Answers0