# Ignition 8.0.8 issue system.dataset.toExcel **URL:** \ **Category:** Ignition Early Access\ **Tags:** ignition80\ **Created:** [March 6, 2020, 2:28am UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868 "2020-03-06T02:28:31Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Post date:** [March 6, 2020, 2:28am UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/1 "2020-03-06T02:28:31Z")
![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/77695a42df9c135bb8c2c97a62a7d04cdb226f00.png) step 1：first test line 1, I can see the output console is a pydataset ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/e/e6e9341e37bfd63ae7177d003705a71a508f281a.png) here is the code: results = system.db.runQuery(“SELECT \* FROM [MaluProduction].[dbo].[CoreType]”) results = system.dataset.toDataSet(results) spreadsheet = system.dataset.toExcel(1, [results]) filePath = “C:\temp\TTT.xls” system.file.writeFile(filePath, spreadsheet) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/ba3c872a9bb041b9257f3c098602883fc04883b7.png) I use the manual code, in the path, temp this is a TTT document come out, but when I open the document , it will report fault and see the upside picture, this bug not have in 7.9.10. ---
**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\ **Post date:** [March 6, 2020, 2:54am UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/2 "2020-03-06T02:54:24Z")
I haven’t done anything like before, keep me online. Here an advice. When I used to write data to excel file from LabView or Matlab, I always used .xlsx with no problems. Try exporting in that extension instead of .xls ---
**Author:** ![Tim](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tim/32/3361_2.png) [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Post date:** [March 6, 2020, 3:07pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/3 "2020-03-06T15:07:20Z")
I have had the same issue in 8.0.7 and 8.0.9. I've had to fall back to exporting to csv for now. I think this may be a related post: > [@\[BUG-15748\] Export excel problem in 8.0.8](http://forum.inductiveautomation.com/t/bug-15748-export-excel-problem-in-8-0-8/32371): > > Hey all, I just updated my Ignition servers to 8.0.8 from 7.9.12 and now I’m having a problem with the system.dataset.exportExcel() function. I get the following error: Traceback (most recent call last): File "\", line 2, in \ File "\", line 10, in dataExport at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetName(XSSFWorkbook.java:906) at org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet(XSSFWorkbook.java:859) at com.… ---
**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\ **Post date:** [March 6, 2020, 4:36pm UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/4 "2020-03-06T16:36:05Z")
This issue is fixed in 8.0.10 🙂 ---
**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Post date:** [March 8, 2020, 6:08am UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/5 "2020-03-08T06:08:44Z")
i see the current version is 8.0.9 when the new version can be download ? ---
**Author:** ![Kevin.Herron](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kevin.herron/32/7259_2.png) [@Kevin.Herron](https://forum.inductiveautomation.com/u/Kevin.Herron)\ **Post date:** [March 8, 2020, 11:59am UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/6 "2020-03-08T11:59:57Z")
Now: [https://inductiveautomation.com/downloads/ignition/8.0.10-rc1](https://inductiveautomation.com/downloads/ignition/8.0.10-rc1) ---
**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Post date:** [March 17, 2020, 7:48am UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/7 "2020-03-17T07:48:10Z")
i have test in 8.0.10RC1, Successed, thanks ---
**Author:** ![yifeiliu08](https://avatars.discourse-cdn.com/v4/letter/y/bbe5ce/32.png) [@yifeiliu08](https://forum.inductiveautomation.com/u/yifeiliu08)\ **Post date:** [March 17, 2020, 7:49am UTC](https://forum.inductiveautomation.com/t/ignition-8-0-8-issue-system-dataset-toexcel/32868/8 "2020-03-17T07:49:15Z")
[Kevin.Herron](http://forum.inductiveautomation.com/u/Kevin.Herron) mentioned in 8.0.10 , i have tried , success, you can also update your gateway