Poorna
Poorna

Reputation: 31

create multiple tab in CSV file through R

I have a query in R, for loading data into .xlsx multiple tabs we use below code

write.xlsx(newtrain, 
           file = 'path/file.xlsx',
           sheetName = 'sheet 1',append=TRUE, row.names=FALSE)  
write.xlsx(newtrain, 
           file = 'path/file.xlsx',
           sheetName = 'sheet 2',append=TRUE, row.names=FALSE) 

same way I wanted to create for .csv file.

Upvotes: 2

Views: 11289

Answers (1)

Sahil Desai
Sahil Desai

Reputation: 3696

you can simply write csv using below code

write.csv(MyData, file = "MyData.csv",row.names=FALSE)

But if you want multiple sheet like xlsx so please refer below link.

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

Upvotes: 1

Related Questions