R Export dataframe to Excel with text columns

Question

I've got a dataframe in R that has around 34000 rows and 10 columns. Some of these columns contain strings. When I try to export to Excel or csv (either via write.xlsx or write.csv or write.table) and then open the file, the results file does not open properly. The format looks very messy and unreadable.

Has anyone got any tips for exporting an R dataframe to Excel or csv, and opening it without any formatting errors in the Excel view?

Might be worthwhile trying out the readr equivalents. For example write_excel_csv() seems to be applicable in your situation. — juljo
– juljo, Commented Sep 16, 2020 at 13:39
Thanks. I tried to use it, but the format on opening the file is still not right. — Varun
– Varun, Commented Sep 16, 2020 at 14:21

wildmangrove · Accepted Answer · 2020-09-16 18:07:16Z

1

Have you tried with openxlsx library

library(openxlsx)
XLSX <- createWorkbook()
addWorksheet(XLSX, "Page name")
writeData(XLSX, "Page name", your_dataframe, startRow = 1, startCol = 1)
saveWorkbook(XLSX, file = "path/data.xlsx", overwrite = TRUE)

answered Sep 16, 2020 at 18:07

wildmangrove

1363 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

R Export dataframe to Excel with text columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related