Get row item error: "StringConverter cannot convert from System.Double"

[Steven_McKeering]

Hello

I am new to using Excel and UiPath together.

I am getting the following error when reading integers in a Datatable from Excel:
“Get Row Item: StringConverter cannot convert from System.Double.”

It can read the cell above which has ‘123t’.

I believe the problem is reading ‘123t’ as a string but reads ‘123’ as an integer.

Any ideas on how to make it read all values as a string?

Error - Activity screenshot:

Error - Output screenshot:

DataTable screenshot (the red cell is where UiPath is getting stuck):

[SenzoD (Senzokuhle Dlomo)]

@Steven_McKeering, Hi

Try this: In your excel file select the column “Keyword”
Right-click and select format cells… and then select text. save and try again.

This will make excel to treat everything in that column as plain text, let me know if that helps:

[Steven_McKeering]

Hey

It didn’t work for me. Thanks for the suggestion.

Same error message: “Get Row Item: StringConverter cannot convert from System.Double.”

[SenzoD (Senzokuhle Dlomo)]

Mind sharing your workflow?

[Steven_McKeering]

Here it is.

Main.xaml (7.2 KB)

Any assistance is appreciated

[Steven_McKeering]

Oh and the reference list is attached

Topic Reference List.xlsx (17.0 KB)

[SenzoD (Senzokuhle Dlomo)]

@Steven_McKeering

My brain is overheating , but I solved it.

Let me know if it works fine.

Example1.zip (29.2 KB)

[Steven_McKeering]

Nice work.

Have a drink on me

[gypsumgaurav (Gaurav)]

I also had the similar issue. I was unable to implement the solution discussed here in my work but I was able to find a solution that worked for me.
You could change the Variable Type of your main variable where the error is occuring to a generic value (UiPath.Core.GenericValue).
Hope it helps.

[Steven_McKeering]

Thank you, this solution worked also.