'Stargazer export to excel (xlsx)

Hi when i'm exporting the regression table (lm(x~y,z,...)) via stargazer and write.xlsx, i always receive the results in one cell including many spaces between the variable and the number.

problem:

enter image description here

Is there a way to receive the excel export in different cells?

The problem is, that the measures to not have the same length depending on their significance level and if it is positive or negative.

I need this for multiple automated outputs, therefore manual copy-paste and CSV are no options.

reg_outputEnjoyment1model1 = lm(Enjoyment1 ~ Appreciation1 + Surveyvalence1 + Surveyarousal1 + posemohingezogen1 + posemoangeregt1 + posemozuversichtlich1 + posemozufrieden1 + posemogeruhrt1 
                          + posemouberrascht1 + posemostolz1 + posemoinspiriert1 + negemoabgestossen1 + negemominderwertig1 + negemotraurig1 + negemoverargert1 + negemohasserfullt1 
                          + negemoenttauscht1 + negemoschlechtesgewissen1 + negemounbeeindruckt1 + actinvolvement11 + actinvolvement12 + actinvolvement13 + brandappeal1 + comprehensability1 
                          + credibility1 + positionining11 + positionining12 + positionining13 + positionining14 + positionining15 + positionining16 +usage1  , data = totaldfmean1)

regressiontableEnjoyment1meanmodel1 <- as.data.frame(str_squish(stargazer(reg_outputEnjoyment1model1, type = "text", align = TRUE, no.space = TRUE)))
regressiontableEnjoyment1meanmodel1gl <- glance(reg_outputEnjoyment1model1)

current result, but still in the same cell, split via separate not possible, because std. deviation in () in second line without a first column...

enter image description here

thanks in advance



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source