how can append r outputs in single sheet of xlsx file? working on web crawling wherein need scrap user reviews website , save in deskstop in xlsx format. need every time change website url(as user reviews in different pages) in code , save output in 1 sheet of xlsx file.
can please me code of appending outputs in single sheet of xlsx file? below code using: every time need change website url , run same below code , save corresponding output in single sheet of mydata.xlsx
library("rvest") htmlpage <- html("http://www.glassdoor.com/gd/reviews/symphony-teleca-reviews-e28614_p2.htm?sort.sorttype=rd&sort.ascending=false&filter.employmentstatus=regular&filter.employmentstatus=part_time&filter.employmentstatus=unknown") proshtml <- html_nodes(htmlpage, ".pros") pros <- html_text(proshtml) pros data=data.frame(pros) library(xlsx) write.xlsx(data, "d:/mydata.xlsx", append=true)
look @ package xlsx.
?write.xlsx show want. append=true key.
========= edit correct =========
as @jakub pointed out, append=true adds worksheet file.
========= edit add: method ==========
another method save data .csv file, open excel. in case, append=t works expected (adding existing sheet):
write.table(df,"d:/myfile.csv",append=t,sep=",") 
Comments
Post a Comment