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
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,
Try this code
dt.Select("Convert(ID, 'System.String') = '" + input+"'").CopyToDataTable()
Thank You,its working!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.