EXTRACTING THE DATA FROM EXCEL (TIMESTAMP), OTHER VALUES ARE BEING EXTRACTED AND USED NORMALLY?

Learn Academy Feedback
, , ,
1

Hi Team,

So I need to extract the data from the excel and use it in future.

So as off now, I am able to use the for each row activity to get the data and use it.

by using the row(5).tostring inside the loop, ideally it should refer to the TimeStamp colunm and show the result. But in my case I am not able to do it.

Again, I did it with other colunms shown in this figure (Version, Operating system, etc) Please refer the image

Capture
Capture738×225 5.2 KB

The problem is only for the timeStamp. (when I tried to get the message box I was getting the random junk values which made no sense eg:- 5483783.244454)

I highly think it is the mater of excel formatting, but i really want to extract the data as it is.

Please help me as soon as possible.

thanks and regards,
@hacky

2

Can you attach a sample excel or workflow

Thanks,
Prankur