0

If I have an excel workbook in R called "wb" and in that workbook I have two sheets one called sheet A and one called sheet C . If I want to create a new sheet that will go between A and B called C how would I do that ?

nesha
  • 7
  • 3
  • 1
    I know the function `worksheetorder` can be used to swap sheet place, and `writeData()` has and argument to specify the index where the sheet you write should be. But I don't know if it works with names instead of index. Anyway, you can do `writeData(wb = data, sheet = 2)` to write a new sheet between 2 sheets that alrdeay exist – MonJeanJean Jul 23 '21 at 07:13
  • 1
    Does [this](https://stackoverflow.com/questions/34731382/add-sheet-to-excel-file) or [this](https://stackoverflow.com/questions/49181980/r-append-a-worksheet-to-an-excel-workbook-without-reading-the-entire-workbook) or [this](https://www.r-bloggers.com/2019/08/creating-excel-workbooks-with-multiple-sheets-in-r/) help? – Naresh Jul 23 '21 at 07:19

0 Answers0