CODEWITHSUNDEEP
rexcelstargazer
bondgirl
bondgirl

Reputation: 11

unable to paste stargazer table from R onto Excel

I am trying to copy paste stargazer table from Rstudio to Excel, and when I click on paste nothing happens. Here is the syntax I am using stargazer(caschool, type="text",median = TRUE, digits=2, title="CA schools dataset")

Upvotes: 0

Views: 210

Answers (1)

Samet Sökel
Samet Sökel

Reputation: 2670

You can export it directly as an excel output in that way;

if(!require(xlsx)){
    install.packages('xlsx')
    library(xlsx)
}else{
    library(xlsx)
}

library(stargazer)

model <- lm(Sepal.Width ~ Petal.Length + Petal.Width + 1,iris)

stargazer_df <- data.frame(stargazer(model,type="text",median = TRUE, digits=2, title="CA schools dataset"))
names(stargazer_df) <- ''

write.xlsx(stargazer_df,file = "stargazer_output.xlsx",sheetName = "Sheet1")

Upvotes: 1

Related Questions