1、get sheetName from code or web ui.
<parameter name="PARAMS_PROVIDER" class="com.citi.gfts.rptapp.jasper.writer.JRParamsProvider" isForPrompting="false"/>
<parameter name="P_FIN_PRES" class="java.lang.String">
<defaultValueExpression><![CDATA[$P{PARAMS_PROVIDER}.getQueryParams().get("P_FIN_PRES")]]></defaultValueExpression>
</parameter>
2、add below part in jasper main report's pageHeader part.
<line>
<reportElement x="0" y="0" width="1" height="1" uuid="141e6753-0b2c-4b74-be35-5826e4df4eb2">
<propertyExpression name="net.sf.jasperreports.export.xls.sheet.name"><![CDATA[$P{P_FIN_PRES}]]></propertyExpression>
</reportElement>
</line>