openxlsx allows invalid characters in worksheet names

[jonas-hag]

Describe the bug
openxlsx allows writing worksheet names that are not supported by Excel.

To Reproduce

1. Save an example file:

library(openxlsx)
write.xlsx(
  mtcars,
  file = "~/test.xlsx",
  sheetName = "mtcars/test"
)

2. Open the file
3. The error message says:

We found a problem with some content in ’test.xlsx’. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.

4. When you try to manually include a / in a worksheet name within Excel, you get the message:

You've typed an invalid name for a sheet or chart. Make sure that:
• The name that you type does not exceed 31 characters.
• The name does not contain any of the following characters: : \ / ? * [ or ].
• You did not leave the name blank.

Expected behavior
write.xlsx should throw an error when any of the above characters are included in a worksheet name.

Desktop (please complete the following information):

• OS: macOS
• openxlsx 4.2.3

Additional context
I'm happy to provide a PR if it should be done in the R code, possibly in buildWorkbook?

[ycphs]

Please check if the PR #213 is a fix for the issue.

[github-actions]

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions]

This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.

[github-actions]

This issue was closed because it has been stalled for 7 days with no activity.