Get row item and process the data retrieved

Help
21

read DTv1.xaml (14.9 KB)

I still have the same problem …
It seems to work halfway when i don’t convert anything to Int32 and juste use String but it doesn’t add well in the Excel file

22

It works for some conditions but sometimes gives me this :

image.png708×252 9.19 KB

23

Hi @lemoinethomas,
Do you have some null values in your input?

24

Yes, sadly it’s not a clean DT …

25

Would you know how to get around that ?

26

Hi @lemoinethomas,
Please implement one check for the null values, If it is Null then first convert it to Zero / “0”.
May be it will solve your error.

Example: If (value=“”) then value=0 else nothing.
we can try something like the above.

Regards,
Jiban

27

Thank you very much, it seems to work now !

1 Like
28

I still get the same error message “Assign : Input string was not in a correct format” …

29

@lemoinethomas Please check your input excel file. Make sure that you are aware of the data types present in the excel file.
According to the data types, you have to handle in code. If it is something else rather than string/text then you have to handle that data type also.

30

The data I am looking for in my file is “Number” type

31

I found the solution : I had to use a “Double” type variable and not a Int32 variable

Thanksfor your help