So lately I have been working on a use-case where I need to extract the data from the excel.
So I have followed the followed the below approach:-
1. Read Range from the excel (excel is shown below) (into data table variable : dt)
2. For each row to get the cell by cell extraction.
3. Using the message box to display (checking purpose)
Now, that being said, I am stuck here, I am able to extract all the items of the rows, but only finding it difficult to extract the row of TimeStamp.
Ideally, I should be able to get the TimeStamp values in the output message box window. But I am getting a random junk values (eg:- 4573982.39894, 45903.8272, etc…)
I also tried getting values of column “Insert Date” but here also I am getting the random(but similar sorta) output.
Please find the images attached below for refference.
Thanks and Regards,