Uipath read from excel

Bot read from excel with the following symbols.

But after read, bot only returns = for all of them. how to make sure bot includes the greater or equal and lesser than or equal symbols?

Hi @TyraS

Use the Read Range properties and Check the Option Preserved Format!


Hi , the preservedFormat is already checked. Oh I think its when inserting into the database, it becomes =

Hi @TyraS

Which database are you Using to insert the value?


Hi, sql server

Hi @TyraS ,

This symbols are unicode , so Try with the following

“insert into temp1 values(N’”+row(“a1”).toString+"’)"

1 Like

N indicates Unicode constant string in MSSQL