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??
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
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.