in order to export a data.frame to sheet.xls i try: write(df,file="file_name.xls") but when i open it a message appears: "impossible to oppen this file. her format is unvalid" knowen that i work with excel_2007 what is the solution ? -- View this message in context: http://www.nabble.com/i-want-to-export-a-data.frame-to-file.xls-tp17326119p17326119.html Sent from the R help mailing list archive at Nabble.com.
hanen wrote:> > in order to export a data.frame to sheet.xls i try: > > write(df,file="file_name.xls") > > but when i open it a message appears: > > "impossible to oppen this file. her format is unvalid" > > knowen that i work with excel_2007 > > what is the solution ? >Hi, write.csv(df,"filename.csv") will save it in .csv format which is readable by excel. Can then be saved as .xls in excel OR ?write.xls (package: xlsReadWrite) Blay ----- Blay S KATH Kumasi, Ghana. -- View this message in context: http://www.nabble.com/i-want-to-export-a-data.frame-to-file.xls-tp17326119p17326619.html Sent from the R help mailing list archive at Nabble.com.
Hi Hanen, Take a look at ?write.table. Also, try this: write.table(df,"file_name.xls",col.names=FALSE,row.names=FALSE,sep="\t") or write.table(df,"file_name.xls",sep="\t") HTH, Jorge On Mon, May 19, 2008 at 3:27 PM, hanen <hanen.mastouri@yahoo.fr> wrote:> > in order to export a data.frame to sheet.xls i try: > > write(df,file="file_name.xls") > > but when i open it a message appears: > > "impossible to oppen this file. her format is unvalid" > > knowen that i work with excel_2007 > > what is the solution ? > -- > View this message in context: > http://www.nabble.com/i-want-to-export-a-data.frame-to-file.xls-tp17326119p17326119.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help@r-project.org mailing list > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > http://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. >[[alternative HTML version deleted]]