Get special characters from excel

hi,I want to read an Excel document which contains numbers,strings,combination of both(numbers&strings)and strings with special characters,can we have a solution for it??

@saran11,

Welcome to UiPath Community!.

You can use Read Range with Excel Application scope activity?

Are you facing any issues?

yes,when I am trying to pass numbers with special characters in input dialogue it throws an exception

@saran11,

Share the error / exception details, screenshot here for better help

what is your variable datatype of input,
If it is double then convert it into string

Try to write like this,
dt.Select(“[ID]='”+input.ToString+“'”).CopyToDataTable

1 Like

Hi @saran11

Try this code

 dt.Select("Convert(ID, 'System.String') = '" + input+"'").CopyToDataTable()
1 Like

Thank You,its working!

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.