I am trying to create a common workbook of output summaries. so I am trying to create a xlsx or csv file where i can append different sheets of output .
I have tried many options but nothing is working, after updating packages xlsx and rjava still write.xlsx not working.
writeData(wb, sheet=domain_ct, domain_ct)
Error in writeData(wb, sheet = domain_ct, domain_ct) :
could not find function "writeData"
> write.table(domain_ct,"C:/shoaib/ER/Uploader/Output_file.csv",append=T,sep=",")
Warning message:
In write.table(domain_ct, "C:/shoaib/ER/Uploader/Output_file.csv", :
appending column names to file
rite.xlsx(domain_ct, file = "Out_file.xlsx", sheetName="domain_ct", append=TRUE)
Error in write.xlsx(domain_ct, file = "Out_file.xlsx", sheetName = "domain_ct", :
could not find function "write.xlsx"
CSV files do not have a structure that supports multiple sheets. If you want the stored file to have different sheets for different data, you cannot write to a CSV file.
I do not have the xlsx package, so I can be of limited help with that. Your attempt to use write.xlsx returned an error that said the function was not found. Hare you run the command
library(xlsx)
Do you want to append data to existing sheets or do you want to make a new sheet for each data set? I am not sure which of those options is done by the append argument. I read the documentation but it is not clear to me.