# Exporting data from a Easy Chart

**URL:** <https://forum.inductiveautomation.com/t/exporting-data-from-a-easy-chart/58326>\
**Category:** Ignition\
**Created:** [April 11, 2022, 8:45pm UTC](https://forum.inductiveautomation.com/t/exporting-data-from-a-easy-chart/58326 "2022-04-11T20:45:47Z")\
**Posts on this page:** 1\
**Showing post:** 9

<div class="post-metadata">

**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:** [April 11, 2022, 11:41pm UTC](https://forum.inductiveautomation.com/t/exporting-data-from-a-easy-chart/58326/9 "2022-04-11T23:41:35Z")

</div>

Consider using Apache POI libraries' API for Microsoft file formats. Start here:

> [@Copying an Excel file to a table's dataset](https://forum.inductiveautomation.com/t/copying-a-excel-file-to-a-tables-dataset/34942/13):
>
> Got my paperwork done early, so here's a sample to read from an Excel file EDIT: Reworked a bit to work with both .xls and .xlsx files EDIT: Modified to properly cast data types EDIT: Added handler for formula cell types EDIT: Added parameters to optionally specify sheet, row, and column numbers Reading back a file created from my other example: def excelToDataSet(fileName, hasHeaders = False, sheetNum = 0, firstRow = None, lastRow = None, firstCol = None, lastCol = None): import org.apac…

Examine the javadocs to work out writing instead of reading.

Total control.

(The java api is included in Ignition v8+. You can add a 3rd party module, like Kymera's office documents module, to get access in v7.9.)

---

_[View the full topic](https://forum.inductiveautomation.com/t/exporting-data-from-a-easy-chart/58326)._