If you look at the documentation ?write_xlsx there is not an append argument defined for this function, thus the error. It has been raised as a possible feature for that package and deemed not possible. You could read the spreadsheet, do the appending in R, and then re-write the full version.
Alternatively, perhaps you would be served by write.xlsx() from the xlsx package which does have this argument and might be suitable for your purposes?
If you look at the documentation
?write_xlsx
there is not anappend
argument defined for this function, thus the error. It has been raised as a possible feature for that package and deemed not possible. You could read the spreadsheet, do the appending in R, and then re-write the full version.Alternatively, perhaps you would be served by
write.xlsx()
from thexlsx
package which does have this argument and might be suitable for your purposes?