Ignition 8.0.8 issue system.dataset.toExcel

Ignition Early Access
1

image
step 1：first test line 1, I can see the output console is a pydataset
image
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
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.

2

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

3

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:

1 Like
4

This issue is fixed in 8.0.10 :slight_smile:

5

i see the current version is 8.0.9 when the new version can be download ?

6

Now: https://inductiveautomation.com/downloads/ignition/8.0.10-rc1

7

i have test in 8.0.10RC1, Successed, thanks

8

Kevin.Herron mentioned in 8.0.10 , i have tried , success, you can also update your gateway