as.range() should be able to surround sheet name with single quotes

[jennybc]

It is possible this should be the default, in fact.

From Google Sheets v4 API:

https://developers.google.com/sheets/api/guides/concepts#a1_notation

If the sheet name has spaces or starts with a bracket, surround the sheet name with single quotes ('), e.g 'Sheet One'!A1:B2. For simplicity, it is safe to always surround the sheet name with single quotes.

[jennybc]

I welcome comments from the Excel side of the house. And will add them myself next time my head is in that place.

[jennybc]

@nacnudus @StevenMMortimer

Do you have any thoughts about this? Can we think of any reason to NOT produce single-quote protected sheet names when cellranger makes a ref string?

[StevenMMortimer]

I think single quotes should be the default. Not just spaces, but any sheet name resembling R1C1 or A1 notation will also cause Excel to surround the name in quotes. See the following example on SO: https://stackoverflow.com/a/41680637/5258043

[nacnudus]

I think it's a reasonable default. The linked API doc doesn't mention that single quotes in the sheet name are escaped by doubling, so if there's a function to extract the sheet name from a ref, it will have to de-escape them. E.g. ='Jenny''s Sheet'!A1