# Export dataset to excel with particular cell in vision

**URL:** <https://forum.inductiveautomation.com/t/export-dataset-to-excel-with-particular-cell-in-vision/73641>\
**Category:** Ignition\
**Tags:** vision, ignition81, scripting, database\
**Created:** [May 12, 2023, 9:55am UTC](https://forum.inductiveautomation.com/t/export-dataset-to-excel-with-particular-cell-in-vision/73641 "2023-05-12T09:55:20Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**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:** [May 12, 2023, 10:51am UTC](https://forum.inductiveautomation.com/t/export-dataset-to-excel-with-particular-cell-in-vision/73641/4 "2023-05-12T10:51:02Z")

</div>

I added an option to offset the export.

> [@Copying an Excel file to a table's dataset](https://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…

```python
sampleHeaders = ['Col1', 'Col2', 'Col3']
sampleData = [['ABC', 123, 9.87],
              ['DEF', 456, 6.54],
              ['GHI', 789, 3.21]
             ]

dataIn = system.dataset.toDataSet(sampleHeaders, sampleData)

util.datasetToExcel(dataIn, 'c:/test/poi offset.xlsx', firstRow=3, firstCol=1)

```

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5bffffafef0c023234f7aedb82cb20a561ea7709.png)

---

_[View the full topic](https://forum.inductiveautomation.com/t/export-dataset-to-excel-with-particular-cell-in-vision/73641)._