How to work on the formatted excel cells?

Help Activities
, ,
1

Hi all,

I would like to extract few details from excel which is formatted as below. i need to extract the Column A Due dates, but all the fields which we are seeing is formatted.

kindly suggest

image
image1011×610 17.4 KB

2

@nvignesh456

If you use a read range then it would still read even if they are formatted

If you want format to be preserved while reading then use display values or Preserve format option

cheers

3

Actually i tried buddy, please see the below attached output.

You cannot see the any dates in Due Date column.

check the A10 cell.

image
image1534×598 23.7 KB

n

4

@nvignesh456

The dates are coming in different format

to convert use DateTime.FromOADate(YourCurrentDateas43523).ToString("MM/dd/yyyy")

second option use preserve format check box or display value option in the read range and read the file …so that the format is preserved

cheers

5

Hi ANil,

please find the attached error below

image
image1920×1080 218 KB

6

@nvignesh456

Please use like this CDBL(str_date)

cheers

7

the expected dates are
image
actual dates are
image

8

I tried with modern excel activity, working fine now.

Thanks

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.