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

2012-12-13 Thread Tammy Ma
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,

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

2012-12-13 Thread Anthony Damico
use append = TRUE inside your write.xlsx() function On Thu, Dec 13, 2012 at 7:52 AM, Tammy Ma metal_lical...@live.com 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

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

2012-12-13 Thread jim holtman
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 metal_lical...@live.com 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.