SectionReport: Custom sheet names when using Excel export with multiple sheets

SectionReport: Custom sheet names when using Excel export with multiple sheets

Posted by: alexander.kainz on 23 April 2026, 8:35 am EST

• 

  alexander.kainz

  • Post Options:
  • Link
    Copy

  Posted 23 April 2026, 8:35 am EST

  I am using an Excel export with multiple sheets configured like this:

  using XlsExport exporter = new()
  {
      FileFormat = FileFormat.Xlsx,
      MultiSheet = true,
      DisplayGridLines = true,
  };

  How can I assign a custom name to each generated sheet during the export?

  Is there a way to define sheet names programmatically for each dataset or section when MultiSheet = true is enabled?

  Thanks.

  Best regards, Alexander

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 24 April 2026, 4:22 am EST

  Hi Alexander,

  Thank you for reaching out to MESCIUS support.

  Sorry for the inconvenience caused. In ActiveReports.NET, there is no supported way to assign unique custom names to each sheet when using MultiSheet = true while exporting to Excel. The exporter generates sheet names internally (e.g., Sheet1, Sheet2, …) and does not provide an API to override them per sheet. While the SheetName property can be set, it only works as a base/prefix name, and the exporter appends an index (e.g., CustomName1, CustomName2, etc.).

  As a workaround, the sheet names can be updated after export by post-processing the file using external libraries. Additionally, you may consider our different product line “Document Solutions for Excel”, which provides more flexibility for working with Excel documents.
  
  https://developer.mescius.com/document-solutions

  Please let us know if you need further assistance.

  Regards,
  
  Prabhat Sharma.