# Xlsxwriter not working in ignition 8

**URL:** <https://forum.inductiveautomation.com/t/xlsxwriter-not-working-in-ignition-8/50590>\
**Category:** Ignition\
**Created:** [September 3, 2021, 7:33am UTC](https://forum.inductiveautomation.com/t/xlsxwriter-not-working-in-ignition-8/50590 "2021-09-03T07:33:15Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ndani](https://avatars.discourse-cdn.com/v4/letter/n/e47774/32.png) [@ndani](https://forum.inductiveautomation.com/u/ndani)\
**Post date:** [September 3, 2021, 7:33am UTC](https://forum.inductiveautomation.com/t/xlsxwriter-not-working-in-ignition-8/50590/1 "2021-09-03T07:33:15Z")

</div>

Hello All,  
I have scheduled reports , that goes out on clients ftps server in .xlsx format. I was using .xlsxlibrary to convert .csv to .xlsx. (ignition 7.9)  
But same script is not working in ignition 8.1. Can anybody share steps about how to make this work.  
I saw one post about Apache POI, but not much familiar with it.  
Any help will be much appreciated.

---

<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:** [September 3, 2021, 10:26am UTC](https://forum.inductiveautomation.com/t/xlsxwriter-not-working-in-ignition-8/50590/2 "2021-09-03T10:26:34Z")

</div>

This thread has scripts going to and from datasets. Shouldn't take much rework to do csv.

> [@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…

---

<div class="post-metadata">

**Author:** ![ndani](https://avatars.discourse-cdn.com/v4/letter/n/e47774/32.png) [@ndani](https://forum.inductiveautomation.com/u/ndani)\
**Post date:** [September 6, 2021, 11:56am UTC](https://forum.inductiveautomation.com/t/xlsxwriter-not-working-in-ignition-8/50590/3 "2021-09-06T11:56:26Z")

</div>

Hello Jordan. Thank you so much for the reply. I tested his and it created the file with the name i wanted in .xlsx format.  
But instead of the sample dataset how can i use report dataset which i have in .csv format?

Nachi

---

<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:** [September 7, 2021, 11:09am UTC](https://forum.inductiveautomation.com/t/xlsxwriter-not-working-in-ignition-8/50590/4 "2021-09-07T11:09:53Z")

</div>

There are quite a few examples of how to convert a csv file to a dataset. Here's one of them.

> [@Convert CSV to Dataset](https://forum.inductiveautomation.com/t/convert-csv-to-dataset/2505):
>
> This code will convert a CSV file to a Ignition Dataset. def readCsvAsDataSet(path): from java.io import BufferedReader,FileReader,File from system.dataset import toDataSet br = BufferedReader(FileReader(path)) line = br.readLine() headers = line.split(',') line = br.readLine() data = [] while line != None: data.append(line.split(',')) line = br.readLine() return toDataSet(headers,data) To use it, you would do something like path = system.file.saveFile(".csv") dataset = app.f…