# Excel report big table in one page

**URL:** <https://forum.inductiveautomation.com/t/excel-report-big-table-in-one-page/30652>\
**Category:** General Discussion\
**Created:** [December 12, 2019, 8:14am UTC](https://forum.inductiveautomation.com/t/excel-report-big-table-in-one-page/30652 "2019-12-12T08:14:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [December 12, 2019, 8:14am UTC](https://forum.inductiveautomation.com/t/excel-report-big-table-in-one-page/30652/1 "2019-12-12T08:14:45Z")

</div>

Hi,  
I created an excel report with one big table (\> 30 rows) but when I receive my excel report by email the table is divided into multiple pages.  
How can I make this table in one Excel page ?

Thanks

---

<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:** [December 12, 2019, 5:08pm UTC](https://forum.inductiveautomation.com/t/excel-report-big-table-in-one-page/30652/2 "2019-12-12T17:08:54Z")

</div>

The simple answer is to change the page properties - just make it a custom size that’s large enough (vertically) to get all of your data onto a single rendered “page”, which will then be converted into a single Excel sheet.

---

<div class="post-metadata">

**Author:** ![DD\_Chelsea](https://avatars.discourse-cdn.com/v4/letter/d/b9e5f3/32.png) [@DD\_Chelsea](https://forum.inductiveautomation.com/u/DD_Chelsea)\
**Post date:** [December 12, 2019, 5:43pm UTC](https://forum.inductiveautomation.com/t/excel-report-big-table-in-one-page/30652/3 "2019-12-12T17:43:51Z")

</div>

Hello, good morning.

I face the same problem, i have the following report:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/87771a7a351dd8adb120595fabb4274a3db8023e.png)

when i save it as xls i get all the data divided in different sheets like the following picture:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/eb3b2e80166dbace0ec239625006b7bb4ea6a6bc.png)

Are you really sure there’s nothing we can do to have all the information in **one sheet**?

Best regards

---

<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:** [December 12, 2019, 5:49pm UTC](https://forum.inductiveautomation.com/t/excel-report-big-table-in-one-page/30652/4 "2019-12-12T17:49:15Z")

</div>

…Yes, there _is_ something you can do - change the page properties to a custom size that’s extremely tall.  
This does make the report unusable if you want to print it as a PDF or something, so you’ll probably want to duplicate the report and make the modifications to a specifically-for-Excel-exporting report.

---

<div class="post-metadata">

**Author:** ![flavien](https://avatars.discourse-cdn.com/v4/letter/f/f475e1/32.png) [@flavien](https://forum.inductiveautomation.com/u/flavien)\
**Post date:** [December 13, 2019, 8:11am UTC](https://forum.inductiveautomation.com/t/excel-report-big-table-in-one-page/30652/5 "2019-12-13T08:11:28Z")

</div>

Hi,  
It works. Thanks !  
Unfortunatly, It’s not dynamic so you have to put an insane page height.