
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, "vn.xlsx", sheetName="Sheet1")   [1]

but when I change sheetName="Sheet2" to add up another country into one sheet. it autimatically deleted which I have down on [1].

index<-unique(dataset$country)
for (i in 1:length(index)){

data<-dataset[dataset$country==index[i],]
(...)
output<-dd
#then how do I create each country's output into one sheet of one excel???

}


Kind regards,
Tammy
 		 	   		  
	[[alternative HTML version deleted]]

