Using createRow function from xlsx to insert new row in Excel?

General
,
1

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)
2

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.