After process completion excel Date & Time automatically changed

[ARahman (Md. Abdur Rahman)]

How to keep same format of Excel Automation…

When my task completed then check in Excel file and find the Excel Date & Time format automatically changed to General format.

1. After Screen Completion Task
   

   

2. Previous Screen Automation Task
   

   

[Palaniyappan (Palaniyappan P)]

Hi
we can concatenate the value of that column with a single quote using assign activity within a for each row loop like this
row(“columnname”) = “'”+row(“columnname”)
so that the format wont get changed
Cheers @ARahman

[ARahman (Md. Abdur Rahman)]

@Palaniyappan, Can you tell me more detials… this is my existing workflow design

[RajeshT (Rajesh)]

Hi @Palaniyappan,

I have faced this issue in one of my workflow,i have changed based on your inputs but am getting below error:

[ARahman (Md. Abdur Rahman)]

Anyone can suggest any better idea on this task?

[ARahman (Md. Abdur Rahman)]

Recently i faced this issues in my workflow. Anyone can suggest me how to manage this task without excel format changed.

[Palaniyappan (Palaniyappan P)]

Hi
Kindly have a view on this

How to keep text format in read range activity

Hi. You did that wrong. PadLeft will fill in all characters up to 7 characters, so it is putting single quote to make it ''28784 instead of '0028784 You want to zero fill it with the “0” character, then just place single quote at the start. Cell = "'"+cell.tostring.padleft(7,cchar(“0“))

Cheers @ARahman @RajeshT

[RajeshT (Rajesh)]

Hi @Palaniyappan @ClaytonM

Good Day!

I have an issue in same scenario which i am dealing with date and my date format is DD/MM/YYYY.
When i use the below code,
PolicyDate=row(“PolicyDate”).ToString.PadLeft(7,cchar(“0”))
Dates which are starting with Zero(0)
example:04/12/2019 becoming 12/4/2019(How can i handle in this scenario)
But dates which are starting with other than zero example:
example:14/12/2019 displaying correctly as 14/12/2019

[ClaytonM]

Hey @RajeshT

Do a search on DateTime.ParseExact()
https://forum.uipath.com/search?q=datetime.parseexact

You don’t want to use .PadLeft() on strings which are dates; you want to go directly to a DateTime type from the string. The leading zeros are meaningless on the string, cause DateTimes can be seen with zeros or without based on your format needs.

A DateTime will be either as MM/dd or dd/MM based on your culture variant. If you use DateTime.ParseExact() then you can parse your string in the format “dd/MM/yyyy” which will give you a DateTime value, which you can format however you would like.

Example:

DateTime.ParseExact(row("PolicyDate").ToString.Trim,“dd/MM/yyyy”,CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

or leave off the .ToString() part on the very end if you want a DateTime type value instead of a string.

Regards

[ARahman (Md. Abdur Rahman)]

My actual problem is not yet solve. Please suggest me if have any good way for same format information copy to another excel file. After write action date & time format changed automatically but i want to same format.

My existing output file with previous file…

My workflow

[ARahman (Md. Abdur Rahman)]

Hi,

Anyone can share any process about this task. Actually I already try many process but not able to complete it.

[RajeshT (Rajesh)]

Hi @ARahman ,

Have your tried with Invoke code ,refer below link

Date Format Issue when converting Text File to Excel File

Hi Team, By using Generate Data Table am converting Text file to Excel file,the data which i have in date format from text file automatically changing to another date format in excel. How can i fix this: Text file Date Data:03-Dec-2019 After converting displaying as:12/3/2019. I want to display the data in same format(03-Dec-2019) in excel file ,by using this variable which i need to send an email in same format. Appreciate your help!!