DateTime.ParseExact the whole Column without looping

Help Studio
, ,
11

Hi @arthurang ,

If the Target Goal for you is to represent the dates in Excel Sheet Column in MM/dd/yyyy format, maybe you could use the Format Cells Activity if you have the latest versions in place.

image
image701×445 18.9 KB

You would require to know which column the Date column is present (A or B or C, in my case it is J), then we can use the Range as J:J. If we do not know the position of the column in the Excel sheet too, we can dynamically be able to find it as well.

Input :
image

Output:
image

Let us know if this method is also a possibility for your case, if unable to find the activities, Enable the Modern Design Experience from the Project Settings Panel and check if you are able to get the activities.