I was getting the error, “TypeError: Unable to convert row x, column y to type class java.lang.Integer” on the line “return system.dataset.toDataSet(headers, data)”, which was traced to
value = cell.getNumericCellValue()
if value == int(value):
value = int(value)
The value it was referring to was a single float within a column of mostly integers
I fixed this error following the logic in "Cannot convert row x column y to type java.lang.Long" by adding
try:
value = float(value)
except:
pass
just before rowOut.append(value). I will update this if I run into problems downstream due to this change.