Excel (ger) Date (double) read and paste

[Crusha (CH)]

Hi, I am trying to read the German date format somehow in Excel and to read this date with the same format as it is in the Excel table. In this case, the German date format has the double format.

datetest.xaml (5.6 KB) testdate.xlsx (8.2 KB)

[balupad14 (Balamurugan)]

Hi @Crusha,

Check this one.

UiPathGo - BalaReva Excel Activities

Hi , In the release Version 2019.2.0. I have added a new activity called Change Cell Type. It changes the format of the value like below. [image] In the Cell Format , can specify the custom format what we have in the excel Like below image. [image] Sample : UiPathGoExcel.zip (18.4 KB) This is the video to configure the package in local. Here is the link to know about the formats. Regards Balamurugan.S

Here is the video demonstration

UiPath | How to change the cell or column format in Excel | Guide (datatype)

Regards
Balamurugan.s

[Crusha (CH)]

Hi,

I do not want to change the format in Excel but I want to adopt and display the specified format.

Look at my .xaml file.

[supermanPunch (Arpan)]

@Crusha Why are you using Read Cell Activity ?

[supermanPunch (Arpan)]

@Crusha In the Message Box use this :

DateTime.FromOADate(read)

Check if it gives you the Date Value.

[Crusha (CH)]

This works. Thanks. So simple