search

tidyverse / googlesheets4

Google Spreadsheets R API (reboot of the googlesheets package)
https://googlesheets4.tidyverse.org
Other
360 stars 53 forks source link

Deleting lines #280

Closed marcofaga closed 1 year ago

marcofaga commented 1 year ago

Hi!!

Is it possible to delete a range of cells without shifting the other cells? I only want to erase all the rows within a specific range, without replacing them. For example, I have a sheet ranging from A1:J1000. I want to wipe out all lines from A8:J1000.

jennybc commented 1 year ago

Do you want to clear cell contents but the cells should still exist?

marcofaga commented 1 year ago

No. I want to remove all empty cells after A7. From A8:J1000. With no replacements. To have the worksheet view showing only the range A1:ZZ7

jennybc commented 1 year ago

If I follow, I think you might want range_delete() or sheet_resize().