I have an excel with a column named Amount. I need to browse to that excel and find the amount value which i received from a different source in this excel and mark that row as yellow color.Currently it is working. However for a scenario belwo it doesnot.
The received Amount is -123.45
The Amount present in the excel in row 5 is 123.45
The Amount Present in the excel in row 10 is -123.45
therefore according to my current code, the BOT verfies the record and says there is a duplicate data and sends a business exception, but actually it had to mark the row 10 with the color.
The code details is:
The Excel file is read to find if there is data or empty file
if emty–>throw exception
if not—>i have used look up range to get the exact cell details of that value
to verify if tehre is no duplicate number , i am using look up range again with the cell address obtained from above to check if there is any other cell address which has the value
if i receive two different cell address, there is duplicate value
if i recieve only one cell address, there is only one value.
in the above scenario i get two different cell value.hence BE is thrown.
Kindly help me