Hi KARTHIK GUTTAPUDI,
I had a similar issue with this also, my solution was to change the excel custom format to a text format, so when the bot retrieves the value it will get exact what you see in the excel.
But I am curious if someone have a solution for it that we dont need to change the excel format. I will keep track of this post. =)
------------------------------
Bruno Raphael Marques de Santana
------------------------------
Original Message:
Sent: Thu May 05, 2022 10:39 PM
From: KARTHIK GUTTAPUDI
Subject: How to read excel columns with custom format
Hi Team,
I have a column with a custom format ( date: yyyy/mm/dd ) as shown in the screenshot, when I try to read this column data using datatable and map row functions I see a numeric value, something like this 44215. I would need the exact value from excel ( 2022/05/23), please suggest
------------------------------
KARTHIK GUTTAPUDI
------------------------------