0 votes

How to export from r to excel to a new sheet in a loop? need to create a sheet i=1 in the book, write an iteration, then i=2, etc.

i=1:10
for ( int x ) {
...loop body...
write.xlsx(file="C:/Users/Aigna/Desktop//Данные_итог.xlsx", sheetname = i, tidy(m_logit), append=TRUE)
}

Can you please tell me how to implement it?

Feb 13, 2023 in Others 432 views

## 1 answer to this question.

0 votes

Try this:

library(xlsx)
write.xlsx(x, file, sheetName="Sheet1")
answered Feb 13, 2023 by
• 63,720 points

0 votes
1 answer

## Change date format of cell in excel from dd.mm.yyyy to yyy/mm/dd ( excel version 2013 )

Hello :)   Excel’s Format Cells function can quickly ...READ MORE

0 votes
1 answer

## Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

0 votes
1 answer

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

0 votes
1 answer

## How to open .xlsx files in MS Excel from VS Code?

Hello, to open xlxs files, or files ...READ MORE

0 votes
1 answer

## Download multiple excel files linked through urls in R

Try something along the lines of: for (i ...READ MORE

0 votes
1 answer

## Excel, How to split cells by comma delimiter into new cells

The Excel manual method: choose Text to Column ...READ MORE

0 votes
1 answer

## Comparing two Excel files in R and returning different titles

Solution: library(tidyverse) dat <- read_xlsx("Book1.xlsx") dat2 <- read_xlsx("Book2.xlsx") book1_output <- anti_join(dat,dat2, ...READ MORE

0 votes
1 answer

## Conversion of PDF file to Excel in R

I looked at the pdf, and it ...READ MORE

0 votes
1 answer

## Write from R into template in excel while preserving formatting

you have the XLConnect package. Read the documentation or the vignette of that ...READ MORE

0 votes
1 answer

## Excel vba domdocument parsing xml from TNT tracking system: in some pcs object load return no document

This error is related to something in ...READ MORE