# \[IGN-14447\]Export Excel from Power table

**URL:** <https://forum.inductiveautomation.com/t/ign-14447-export-excel-from-power-table/113222>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [January 12, 2026, 6:43pm UTC](https://forum.inductiveautomation.com/t/ign-14447-export-excel-from-power-table/113222 "2026-01-12T18:43:24Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [January 12, 2026, 6:43pm UTC](https://forum.inductiveautomation.com/t/ign-14447-export-excel-from-power-table/113222/1 "2026-01-12T18:43:24Z")

</div>

Before migrate to version 8.3 I was exporting the power table data with no issues

After migration it doesn’t work

I am using this code

 ![{3EB7134B-42D5-47E6-9137-B83FD8DFE8FD}](https://us1.discourse-cdn.com/inductiveautomation/original/3X/1/e/1ec2b5e4baca759aa8ebd82cb3b8d49d00a42a68.png)

Now I get this error

* * *

**Traceback (most recent call last):  
File "event:actionPerformed", line 8, in  
java.lang.ArrayStoreException: java.lang.ArrayStoreException: arraycopy: element type mismatch: can not cast one of the elements of java.lang.Object[] to the type of the destination array, com.inductiveautomation.ignition.common.Dataset**

```python
caused by ArrayStoreException: arraycopy: element type mismatch: can not cast one of the elements of java.lang.Object[] to the type of the destination array, com.inductiveautomation.ignition.common.Dataset

```

**Ignition v8.3.2 (b2025120210)  
Java: Azul Systems, Inc. 17.0.16**

* * *

Help welcome.

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:** [January 12, 2026, 7:31pm UTC](https://forum.inductiveautomation.com/t/ign-14447-export-excel-from-power-table/113222/2 "2026-01-12T19:31:07Z")

</div>

This is a (minor) bug caused by the automatic wrapping of datasets as "PyDatasets", which makes them act as sequences and fall down a different code path in functions such as `exportExcel` that accept both single elements and lists.

The fix is extremely simple; change:  
`system.dataset.exportExcel(fName, 1, tablet1)`  
to:  
`system.dataset.exportExcel(fName, 1, [tablet1])`

To explicitly pass a list of datasets into the function.

We're planning to address this and related issues (e.g. with `toExcel`) in an upcoming 8.3 release, but it's not the highest priority since the workaround is so easy.

* * *

That aside, I'll make an obligatory mention that you should avoid Python/Jython's stdlib `datetime` and prefer to use functions from the `system.date` package, for your sake down the road for maintenance. It's not a big deal for simple string formatting operations as you have here, but for any complicated date math you want to avoid `datetime`.

EDIT:  
There's the original, knew this felt familiar:

> [@\[IGN-14447\]system.dataset.toExcel not working after updating to 8.3](https://forum.inductiveautomation.com/t/ign-14447-system-dataset-toexcel-not-working-after-updating-to-8-3/112749/2):
>
> So, the short version is: Update your script to system.dataset.toExcel(True, [value]) and everything will start working fine. The medium version is that toExcel has always been documented to accept a list of datasets (which will become 'sheets' in the final document, 1:1 with input datasets). That it accepts a single dataset is a convenience feature we're deliberately not documenting because the list form is "more correct". The long version is that this broke with the transition to 8.3 becaus…

---

<div class="post-metadata">

**Author:** ![Alfredo\_Egmo](https://avatars.discourse-cdn.com/v4/letter/a/ccd318/32.png) [@Alfredo\_Egmo](https://forum.inductiveautomation.com/u/Alfredo_Egmo)\
**Post date:** [January 12, 2026, 8:09pm UTC](https://forum.inductiveautomation.com/t/ign-14447-export-excel-from-power-table/113222/3 "2026-01-12T20:09:47Z")

</div>

that works, thank you.