# Exporting Report to Excel - Single Sheet **URL:** \ **Category:** Ignition\ **Created:** [March 8, 2019, 7:37pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176 "2019-03-08T19:37:59Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![andytimc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/andytimc/32/11938_2.png) [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Post date:** [March 8, 2019, 7:37pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/1 "2019-03-08T19:37:59Z")
Is there any way to export a report to excel that will put all the data on a single sheet. Right now my report is being broken up into 8 sheets. I know I can expand the height of the page to some huge number to force it to a single sheet, but I’m wondering if there is some setting i’m missing that would just force the report to a single sheet. ---
**Author:** ![rpulsifer](https://avatars.discourse-cdn.com/v4/letter/r/e9a140/32.png) [@rpulsifer](https://forum.inductiveautomation.com/u/rpulsifer)\ **Post date:** [May 7, 2019, 5:26pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/2 "2019-05-07T17:26:55Z")
Did you find an answer? I’ve tried grouping and reviewed the IU videos and still get a page per “sheet”… ---
**Author:** ![andytimc](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/andytimc/32/11938_2.png) [@andytimc](https://forum.inductiveautomation.com/u/andytimc)\ **Post date:** [May 7, 2019, 6:03pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/3 "2019-05-07T18:03:42Z")
No I was never able to find a solution to this. My single page is just incredibly long so that it exports to a single page. But its difficult to work with on the design side. ---
**Author:** ![jorge.galvez](https://avatars.discourse-cdn.com/v4/letter/j/ecb155/32.png) [@jorge.galvez](https://forum.inductiveautomation.com/u/jorge.galvez)\ **Post date:** [February 3, 2021, 9:10pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/4 "2021-02-03T21:10:04Z")
Hello! Did you find a way to solve this? I have the same need with a report which has lot of rows and I want only one sheet. ---
**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:** [February 3, 2021, 9:33pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/5 "2021-02-03T21:33:14Z")
> [@andytimc](#): > > I know I can expand the height of the page to some huge number to force it to a single sheet This is the only "solution" to this problem. The reporting engine doesn't collapse report content down in any other way. ---
**Author:** ![brian\_netz](https://avatars.discourse-cdn.com/v4/letter/b/cc9497/32.png) [@brian\_netz](https://forum.inductiveautomation.com/u/brian_netz)\ **Post date:** [December 1, 2021, 4:34pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/6 "2021-12-01T16:34:19Z")
I’m a little late to the party, but I just ran into this myself. You can export it as a .csv file to have everything on one ‘sheet’. ---
**Author:** ![Muhammad\_Anas](https://avatars.discourse-cdn.com/v4/letter/m/aca169/32.png) [@Muhammad\_Anas](https://forum.inductiveautomation.com/u/Muhammad_Anas)\ **Post date:** [August 17, 2022, 3:42pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/7 "2022-08-17T15:42:57Z")
Yes but the csv file repeats the header after every so many rows that fit on one sheet in the case of an excel file. ---
**Author:** ![Maria\_P](https://avatars.discourse-cdn.com/v4/letter/m/838e76/32.png) [@Maria\_P](https://forum.inductiveautomation.com/u/Maria_P)\ **Post date:** [November 26, 2024, 3:31pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/8 "2024-11-26T15:31:22Z")
Just posting as I'd be also interested in getting all rows in a single sheet. Expanding height would not work in all cases because amount of data can be different regarding user inputs. ---
**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:** [November 26, 2024, 4:07pm UTC](https://forum.inductiveautomation.com/t/exporting-report-to-excel-single-sheet/23176/9 "2024-11-26T16:07:18Z")
Ignition include the Apache POI java libraries, which allow custom construction of arbitrary Excel files from your data. (Also some built-in, like [system.dataset.toExcel()](https://www.docs.inductiveautomation.com/docs/8.1/appendix/scripting-functions/system-dataset/system-dataset-toExcel), among others.) Numerous script examples are on this forum. The reporting module's primary purpose is to make printable PDF files. The alternate formats are renderings of page-based PDFs.