Is net.sf.jasperreports.export.xls.sheet.name usable?

[mwarner_2]

I want to export to Excel.  My summary page goes on a separate tab.  My data goes in the tab(s) before the Summary tab.  I don't really care if those tabs are named Page 1, Page 2, etc.  Don't know how many tabs like that I will have.

 

What I do care about is naming the Summary tab.  I have read that there is a "net.sf.jasperreports.export.xls.sheet.name" property to set the name of a tab.  But using Report Studio, when I go to the Summary band, Properties, Advanced, Properties, ..., Add there that Property is not available in the dropdown list.  Even if I go to the Source XML tab, and enter "property name="net.sf.jasperreports.export.xls.sheet.name" value="Summary"/> it has no effect on the sheet names.

 

So what am I missing?

[hozawa]

You don't need to go to xml source, you can just enter "net.sf.jasperreports.export.xls.sheet.name" in the property name field and enter the value.

[mwarner_2]

Yes I can enter it in a property name field, but still it does NOT give the name to the Excel tab.  No matter where I entered ...export.xls.sheet.name... it still Never named any Excel tab.

 

So please tell me where to enter it so that it works.