# Export power table data set to Excel as an Excel Table

**URL:** <https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647>\
**Category:** General Discussion\
**Created:** [February 20, 2021, 4:40am UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647 "2021-02-20T04:40:02Z")\
**Posts on this page:** 1\
**Showing post:** 5

<div class="post-metadata">

**Author:** ![Derekr](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/derekr/32/4945_2.png) [@Derekr](https://forum.inductiveautomation.com/u/Derekr)\
**Post date:** [February 23, 2021, 3:36pm UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647/5 "2021-02-23T15:36:06Z")

</div>

> [@Copying an Excel file to a table's dataset](https://forum.inductiveautomation.com/t/copying-an-excel-file-to-a-tables-dataset/34942/7):
>
> def datasetToExcel(dsIn, fileName, sheetName = 'Sheet1'): import org.apache.poi.ss.usermodel.Cell as Cell import org.apache.poi.ss.usermodel.Row as Row import org.apache.poi.ss.usermodel.Sheet as Sheet import org.apache.poi.ss.usermodel.Workbook as Workbook import org.apache.poi.xssf.usermodel.…

Thank you. I am unfamiliar with apache.poi so I need to do some research, but at least I have a place to start.

---

_[View the full topic](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647)._