Recommended way to clear an area in an existing Excel sheet

[Mastomaki]

What is the recommended way to clear an area in an existing Excel sheet?

[nathanrboyer]

You could just write over the cells with empty strings.

XLSX.openxlsx("testfile.xlsx", mode="rw") do file
   sheet = file[1]
   for col in 3:4, row in 2:3
       sheet[row, col] = ""
   end
end

sheet[row, col] = missing also works.