Copying an Excel file to a table's dataset

[Sayantan_Chatterjee]

Hi Jordan
If in the excel sheet one column consist of integer and string both kind of data, its giving error. Here column 3 is giving error.

[JordanCClark]

@lrose

Make sure that your work book columns do not have mixed data types, (i.e. String, Double). In the work book you provided the column for peel thickness row 6 was the value 0.191., row 7 was 0.210. and row 8 was "Test". Those are strings and the conversion to dataset will fail because columns can only contain one type. If it needs to be mixed, then they should all be strings.

What happens of you set the cell formatting to text?

[Sayantan_Chatterjee]

Yes. I have made the cell format in text but it doesn't help

[lrose]

What is the error?

[Sayantan_Chatterjee]

Traceback (most recent call last):
File "", line 135, in
File "module:ExcelData", line 91, in excelToDataSet
TypeError: Unable to convert row 2, column 5 to type class java.lang.String