Hello! I suggest you take a look at this, do you think it would be good to also add these other checks?

Edit: oops, the other checks already exist, I missed them, sorry about that. However I noticed your regex does not catch single quotes, was this intended?

hi,papb,Your method is more concise, I think it's very good.
I didn't write according to the assertvalidsheetname method before, because the validation of name in the original code did not always throw an exception. In this way, how to organize it becomes very strange.

About double quotation marks

It seems that the naming rules of sheet have something to do with the version of Excel

As for single quotation marks

As far as I know(Just now), single quotation marks can be placed in the middle, but not the head and tail. Can you test the single quotation marks for me?

Although here has been a long long times since this change applied.
But I suppose if replace invalid character with _ should be a better choice?
Current solution is kinda a breaking change, code running successful (but not correct?) before and will break after update to later version.