When I create xlsx file and set worksheet's title with spaces inside and then I am trying to add print title rows this way:
ws.print_title_rows = '1:1'
I get exception from MSExcel.
I look into xml and see this
<definedName localSheetId="3" name="_xlnm.Print_Titles"> 'title with spaces!1:1' </definedName>
I suppose that closing quotation mark is in wrong place, I think it should be just before exclamation mark
'title with spaces'!$1:$1
I use Python 2.7 and openpyxl 2.4.1