Re: [R] How to create multiple country's data into multiple sheets of one excel

I use the XLConnect package to write out multiple sheets to an Excel workbook On Thu, Dec 13, 2012 at 7:52 AM, Tammy Ma wrote: > > HI, > > > I have large dataset of many countries. I have written the program to run > through each country to generate one output for each country. I want to put >

Re: [R] How to create multiple country's data into multiple sheets of one excel

use append = TRUE inside your write.xlsx() function On Thu, Dec 13, 2012 at 7:52 AM, Tammy Ma wrote: > > HI, > > > I have large dataset of many countries. I have written the program to run > through each country to generate one output for each country. I want to put > the output like this: > >

[R] How to create multiple country's data into multiple sheets of one excel

HI, I have large dataset of many countries. I have written the program to run through each country to generate one output for each country. I want to put the output like this: one sheet has output for one country. How do I achieve it by r. I have tried this: library(xlsx) write.xlsx(nnn, "v