Title with spaces & print title causes excel error
Created originally on Bitbucket by pmichalo (Michal)
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:
#!python
ws.print_title_rows = '1:1'
I get exception from MSExcel.
I look into xml and see this
#!xml
<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
#!xml
'title with spaces'!$1:$1
I use Python 2.7 and openpyxl 2.4.1