# Export power table data set to Excel as an Excel Table **URL:** \ **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:** 7\ **Page:** 1
**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 20, 2021, 4:40am UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647/1 "2021-02-20T04:40:02Z")
I am trying to figure our how to export data from a power table to excel formatted as an excel table, any help would be apprecated. ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [February 20, 2021, 11:34am UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647/2 "2021-02-20T11:34:39Z")
What version of Ignition? ---
**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 22, 2021, 5:32pm UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647/3 "2021-02-22T17:32:04Z")
8.1.2 ---
**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Post date:** [February 22, 2021, 8:03pm UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647/4 "2021-02-22T20:03:51Z")
I know the topic is different, but trust me. > [@Copying an Excel file to a table's dataset](http://forum.inductiveautomation.com/t/copying-a-excel-file-to-a-tables-dataset/34942/7): > > The [Apache POI](https://poi.apache.org/apidocs/4.1/index.html) libraries are included with Ignition. At the time I was only needing to read files, so xlrd was all that was necessary. I'm just starting to dig into POI, myself, but here's a start: EDIT 2021-08-23: Updated to allow JsonDataSets. Changed to allow for a ByteArray output instead of writing to a file. EDIT 2023-01-20: Added option for date formats. Default is 'yyyy-MM-dd hh:mm:ss'. EDIT 2023-05-12: Added options for first row and column, if needed to offset from A1 def datasetT… ---
**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")
> [@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. ---
**Author:** ![tohhy-pm17](https://avatars.discourse-cdn.com/v4/letter/t/e19adc/32.png) [@tohhy-pm17](https://forum.inductiveautomation.com/u/tohhy-pm17)\ **Post date:** [August 5, 2021, 9:17am UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647/6 "2021-08-05T09:17:38Z")
Hi @Derekr, may I know that did you solve the problem that you mentioned above because I also studying this thread which recommend by @JordanCClark and I also unfamiliar with apache.poi so if you had done some script. Hope you can share with me for refer purpose. Thanks in advance ---
**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:** [August 5, 2021, 7:56pm UTC](https://forum.inductiveautomation.com/t/export-power-table-data-set-to-excel-as-an-excel-table/43647/7 "2021-08-05T19:56:18Z")
Sorry Tohhy I did not. The solution was too complicated so we dropped it