I'm trying to use the createRow function from the xlsx package to insert a new row into an Excel table, but it just overwrites the data already in the row rather than inserting a new row. Is it possible to insert a new row, rather than overwriting the old?
wb <- loadWorkbook("Test")
sheets <- getSheets(wb)
sheet1 <- sheets[[1]]
row <- createRow(sheet = sheet1,rowIndex = 3)
saveWorkbook(wb,outfilename)