Delete empty rows using openxlsx

When I Export my data using saveworkbook, there are misisng rows in between my data, how do I get rid of them? I understand that I am able to use this function to delete rows but the function only deletes them based on their index.

deleteData(wb, sheet = 1, cols = 3, rows = 18, gridExpand = TRUE)

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.