Excel Export with dynamic sheet names

Posted by: sevilsizer on 22 June 2020, 8:07 am EST

    • Post Options:
    • Link

    Posted 22 June 2020, 8:07 am EST

    I am new to AR and have recently inherited a project using AR v12. I see that as part of AR v11, feature request ID: 207299 implemented a new property of the ExcelRendingExtensionSettings object called SheetName. When paired with the MultiSheet property, I have seen this generate results like Sheet1, Sheet2, etc (with SheetName by default being set to “Sheet”). Is there a way to dynamically name the sheets based on the data that the report is breaking on? e.g. if I am page breaking on a field “Region” with values like North, South, Central, etc…is there a way to name the sheets something more relevant than Sheet1, Sheet2, Sheet3?

  • Posted 22 June 2020, 6:55 pm EST

    Hello,

    Sorry to mention that it is not possible to give the dynmaic name to the excel sheet.

    Thanks,

    Mohit

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels