在单张xlsx文件中附加r输出 [英] Appending r output in a single sheet of xlsx file

问题描述

如何将我的R输出附加到一张xlsx文件中?我目前正在进行网络抓取，其中我需要从网站上抓取用户评论，并将其以xlsx格式保存在我的桌面停顿中.我每次都需要在代码中更改网站网址(因为用户评论位于不同的页面中)，并将输出保存在一张xlsx文件中.

How can i append my R outputs in a single sheet of xlsx file? I am currently working on web crawling wherein i need to scrap the user reviews from website and save it in my deskstop in xlsx format. I need to every time change the website url(as user reviews are in different pages) in my code and save the output in one sheet of xlsx file.

您能帮我在一张xlsx文件中附加输出的代码吗?下面是我正在使用的代码:每当我需要更改网站URL并运行下面的相同代码并将相应的输出保存在mydata.xlsx

Can you please help me with the code of appending outputs in a single sheet of xlsx file? Below is the code which i am using: Every time i need to change the website url and run the same below code and save the corresponding output in a 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)

推荐答案

查看包 xlsx .

?write.xlsx 将显示您想要的内容. append = TRUE 是关键.

?write.xlsx will show you what you want. append=TRUE is the key.

=========编辑正确=========

正如@Jakub指出的那样， append = TRUE 将另一个工作表添加到文件中.

As @Jakub pointed out, append=TRUE adds another worksheet to the file.

=========另一种方法==========

另一种方法是将数据保存到 .csv 文件，该文件可以从excel中轻松打开.在这种情况下， append = T 可以按预期工作(添加到现有工作表中):

Another method is to save the data to a .csv file, which could easily open from excel. In this case, the append=T works as expected (adding to the existing sheet):

write.table(df,"D:/MyFile.csv",append=T,sep=",")

这篇关于在单张xlsx文件中附加r输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！