Feature Request: Writing to named regions

[deanchen]

Would be very helpful if it is also possible to write to named regions. Would also be helpful to return the cell range and sheet id in the getNamedRegions response.

The use case is populating existing Excel templates containing named regions from R.

[awalker89]

Reopened - write to named region functionality

[bilydr]

@awalker89 I see that this feature is almost done except for the deleteNamedRegions function (re #264) which is announced for version 4.1.0 but not really included. Could you please advise? thanks!

[capitantyler]

I need similar to overwrite printArea

createNamedRegion(
  wb = wb, sheet = sh, 
  rows = 1:n, cols = 1:n, 
  name = "_xlnm.Print_Area"
)