# Exporting a report as a spreadsheet

**URL:** <https://forum.inductiveautomation.com/t/exporting-a-report-as-a-spreadsheet/104972>\
**Category:** Ignition\
**Tags:** reporting, scripting\
**Created:** [April 10, 2025, 7:45pm UTC](https://forum.inductiveautomation.com/t/exporting-a-report-as-a-spreadsheet/104972 "2025-04-10T19:45:20Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [April 10, 2025, 7:58pm UTC](https://forum.inductiveautomation.com/t/exporting-a-report-as-a-spreadsheet/104972/3 "2025-04-10T19:58:11Z")

</div>

> [@Evan\_Curry](#):
>
> is it possible to export this data to an excel speadsheet that has 2 tabs?

Not via the reporting module.

I would seriously consider not using the reporting module for this at all.  
If you have a strictly defined export format, you could create that once as a template, then use the Apache POI library embedded in Ignition to fill it with the selected data.

Put all the logic to generate your report into the project library, then invoke it via a gateway scheduled script.

Some prior art on POI:

> [@Convert Dataset to Excel Using Apache POI module](https://forum.inductiveautomation.com/t/convert-dataset-to-excel-using-apache-poi-module/92351/6):
>
> Taking a closer look, the workbook definition needs to happen for every workbook you are creating. Try moving it to inside the Excel\_data function. from java.io import ByteArrayOutputStream, FileOutputStream, File from org.apache.poi.xssf.usermodel import XSSFWorkbook from org.apache.poi.ss.usermodel import CellStyle, BorderStyle, FillPatternType, IndexedColors def Excel\_data(dataset, Carrier\_id,Function\_Name): # Define styles for the header and rows def create\_styles(workbook): …

> <https://github.com/JordanCClark/ignition_utils/blob/30fcfb9cc3545fa67da718ae82c918013b475940/dataset>

And a (Java) reference for loading an existing workbook as a 'template':

> <https://stackoverflow.com/questions/714172/using-excel-templates-with-apache-poi>

---

_[View the full topic](https://forum.inductiveautomation.com/t/exporting-a-report-as-a-spreadsheet/104972)._