# Report download xls

**URL:** <https://forum.inductiveautomation.com/t/report-download-xls/22114>\
**Category:** Ignition\
**Created:** [January 25, 2019, 9:44am UTC](https://forum.inductiveautomation.com/t/report-download-xls/22114 "2019-01-25T09:44:20Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alok.Vijayakumar](https://avatars.discourse-cdn.com/v4/letter/a/e19b73/32.png) [@Alok.Vijayakumar](https://forum.inductiveautomation.com/u/Alok.Vijayakumar)\
**Post date:** [January 25, 2019, 9:44am UTC](https://forum.inductiveautomation.com/t/report-download-xls/22114/1 "2019-01-25T09:44:21Z")

</div>

when i try to download report in xls format from the report viewer on button click, i am receiving following error

Traceback (most recent call last):

File “event:actionPerformed”, line 16, in

com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: com.inductiveautomation.ignition.client.gateway\_interface.GatewayException: org.apache.poi.hssf.usermodel.HSSFSimpleShape cannot be cast to org.apache.poi.hssf.usermodel.HSSFTextbox

```
caused by GatewayException: org.apache.poi.hssf.usermodel.HSSFSimpleShape cannot be cast to org.apache.poi.hssf.usermodel.HSSFTextbox
caused by ClassCastException: org.apache.poi.hssf.usermodel.HSSFSimpleShape cannot be cast to org.apache.poi.hssf.usermodel.HSSFTextbox

```

Ignition v7.9.9 (b2018081621)  
Java: Oracle Corporation 1.8.0\_201

---

<div class="post-metadata">

**Author:** ![KathyApplebaum](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kathyapplebaum/32/7261_2.png) [@KathyApplebaum](https://forum.inductiveautomation.com/u/KathyApplebaum)\
**Post date:** [January 25, 2019, 3:36pm UTC](https://forum.inductiveautomation.com/t/report-download-xls/22114/2 "2019-01-25T15:36:02Z")

</div>

Can you send this in to support?

---

<div class="post-metadata">

**Author:** ![drojas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drojas/32/3403_2.png) [@drojas](https://forum.inductiveautomation.com/u/drojas)\
**Post date:** [April 7, 2020, 6:02pm UTC](https://forum.inductiveautomation.com/t/report-download-xls/22114/3 "2020-04-07T18:02:23Z")

</div>

Same thing here when right clicking on a report and selecting Save as XLS. Happens on 7.9.10 and 7.9.13. Also happens when I script a button with component.saveAsXls(“Report”) function. Unfortunately, xls isn’t an option for system.report.executeAndDistribute(…) function so I don’t know of any other way to get an Excel version of the report. Has anyone been able to get this to work?

---

<div class="post-metadata">

**Author:** ![drojas](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/drojas/32/3403_2.png) [@drojas](https://forum.inductiveautomation.com/u/drojas)\
**Post date:** [June 3, 2020, 5:27pm UTC](https://forum.inductiveautomation.com/t/report-download-xls/22114/4 "2020-06-03T17:27:04Z")

</div>

As a follow up. We were able to get the exporting to work correctly by removing any “Line” shapes and any rogue “Text” shapes that that were empty. “Text” shapes seem to export as text box objects in Excel. Whenever possible, try putting text shapes inside the header of a Table (not Simple Table…that doesn’t work either) and it will place them inside a cell in Excel. Unfortunately, this requires to have 2 versions of the same report…one that looks good as a PDF, and one that will export nicely as an Excel spreadsheet.