how to write multiple dataframe to multiple sheet of one csv excel file in R?

Question

I am trying to write multiple dataframe to a single csv formated file but each in a different sheet of the excel file:

write.csv(dataframe1, file = "file1.csv",row.names=FALSE)
write.csv(dataframe2, file = "file2.csv",row.names=FALSE)

is there any way to specify the sheet along with the csv file in this code and write them all in one file?

thank you in advance,

with package WriteXLS ? csv is a text file, I really don't think you can have sheets in csv... — Cath
– Cath, Commented Nov 18, 2014 at 8:44
@CathG :yeah right sorry,i meant one excel file with a csv format — f.a
– f.a, Commented Nov 18, 2014 at 8:50
@f.a Do you mean to collapse all dataframes into 1 dataframe, then output into 1 CSV file? — zx8754
– zx8754, Commented Nov 18, 2014 at 8:51
@zx8754, No I mean to write each dataframe in each sheet of the csv formated excel file — f.a
– f.a, Commented Nov 18, 2014 at 9:02
WriteXLS is the answer. There is no such thing as Excel file with CSV sheets... — zx8754
– zx8754, Commented Nov 18, 2014 at 9:11

Arun Raja · Accepted Answer · 2014-11-18 09:49:49Z

4

This is not possible. That is the functionality of csv to be just in one sheet so that you can view it either from notepad or any other such software. If you still try to write it would get over ridden. Just try to open a csv and open a new sheet and just write some values and save it. The values which were already there is erased. one excel file in csv format can have only one sheet.

answered Nov 18, 2014 at 9:49

Arun Raja

1,69417 silver badges26 bronze badges

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

2 Comments

f.a Over a year ago

yeah, right, thank you @Arun Raja , as zx87546 and CathG commented, I could have multiple sheet in a single excel file through WriteXLS

Arun Raja Over a year ago

XLConnect is better. Try that. You can define the number of sheets while writing. getsheets() gives the number of sheets while reading it back.

Taylor White · Accepted Answer · 2014-11-18 17:58:32Z

0

The xlsx and XLConnect packages will do the trick as well.

answered Nov 18, 2014 at 17:58

Taylor White

6845 silver badges11 bronze badges

Collectives™ on Stack Overflow

how to write multiple dataframe to multiple sheet of one csv excel file in R?

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related