[R] i want to export a data.frame to file.xls

Blay sbnguah at yahoo.com
Mon May 19 21:53:21 CEST 2008




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.



More information about the R-help mailing list