# Naming report xlsx sheet names

**URL:** <https://forum.inductiveautomation.com/t/naming-report-xlsx-sheet-names/105481>\
**Category:** Ignition\
**Tags:** perspective, ignition81\
**Created:** [April 23, 2025, 7:12pm UTC](https://forum.inductiveautomation.com/t/naming-report-xlsx-sheet-names/105481 "2025-04-23T19:12:03Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joe\_Lockwood1](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@Joe\_Lockwood1](https://forum.inductiveautomation.com/u/Joe_Lockwood1)\
**Post date:** [April 23, 2025, 7:12pm UTC](https://forum.inductiveautomation.com/t/naming-report-xlsx-sheet-names/105481/1 "2025-04-23T19:12:03Z")

</div>

Is it possible to name sheet names in an XLSX report?  
Currently, when I run the report, I use the report grouping to separate the data into separate sheets. The issue I'm having is that the sheet names are "Sheet0", "Sheet1", "Sheet2", etc. Ideally, this would be the Group name.

Here is my current script I am running.

```python
	overrides = {"Report Dataset":self.getSibling("Table").props.filter.results.filteredDataSet}
	bytesArray = system.report.executeReport(path = "Report Name", project = "Inventory", parameters = overrides, fileType="xlsx")
	filename = "ReportName.xlsx"
	system.perspective.download(filename, bytesArray)

```

This works as stated, with the only issue being that I'm unable to rename the sheets using their group name.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 23, 2025, 7:20pm UTC](https://forum.inductiveautomation.com/t/naming-report-xlsx-sheet-names/105481/2 "2025-04-23T19:20:19Z")

</div>

This type of customization needs to be done directly with the Apache POI libraries, not with the reporting module. Consider scripting the spreadsheet generation from scratch.

My Tag Report Utility on the Exchange has code you can copy and paste for this.

---

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [April 23, 2025, 7:55pm UTC](https://forum.inductiveautomation.com/t/naming-report-xlsx-sheet-names/105481/3 "2025-04-23T19:55:28Z")

</div>

FYI, `system.dataset.toExcel` takes a parameter `sheetNames`:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/4/449f1275712c32a7d429d984b10432318acd0c8e.png)

---

<div class="post-metadata">

**Author:** ![Joe\_Lockwood1](https://avatars.discourse-cdn.com/v4/letter/j/e47774/32.png) [@Joe\_Lockwood1](https://forum.inductiveautomation.com/u/Joe_Lockwood1)\
**Post date:** [April 23, 2025, 8:00pm UTC](https://forum.inductiveautomation.com/t/naming-report-xlsx-sheet-names/105481/4 "2025-04-23T20:00:47Z")

</div>

This looks like it would be a much easier solution. Thanks so much!

Do you know if there's a way also to have it transfer formatting, such as background color? Thinking at this point a pdf maybe a better approach.

---

<div class="post-metadata">

**Author:** ![Ryan\_Deardorff](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan_deardorff/32/63815_2.png) [@Ryan\_Deardorff](https://forum.inductiveautomation.com/u/Ryan_Deardorff)\
**Post date:** [April 23, 2025, 8:05pm UTC](https://forum.inductiveautomation.com/t/naming-report-xlsx-sheet-names/105481/5 "2025-04-23T20:05:37Z")

</div>

> [@Joe\_Lockwood1](#):
>
> Do you know if there's a way also to have it transfer formatting

I don't think there is, but I would love to be proven wrong.