Write range excel format chaged

Help Studio
, ,
1

Hello guys i have an excel with date format column

image
image332×588 17.3 KB

When i read and write it to other excel excel format changed like below,

image
image323×517 7.82 KB

  1. I have used workbook activity for both read and write.
  2. i used preserve format in the read range property also
    is there any other solution for this.
2

Hi @Gokul_Murali

Can you try with Format cells activity

Regards,

4

Hie @Gokul_Murali when you are using Read range enable the preserve Format and the write the data hope it work and let me know

The image shows a UiPath workflow with the "Read Range Workbook" activity configured to read data from "Sheet1" and the "Write Range Workbook" activity configured to write data to "Sheet2," with the "PreserveFormat" option checked in the properties panel. (Captioned by AI)
The image shows a UiPath workflow with the "Read Range Workbook" activity configured to read data from "Sheet1" and the "Write Range Workbook" activity configured to write data to "Sheet2," with the "PreserveFormat" option checked in the properties panel. (Captioned by AI)954×532 35.4 KB

cheers Happy Automation

5

i have enabled that also

6

@Gokul_Murali

can you try with excel activities, if possible share your sample excel

Regards,

7

This excel contain like 50000 data when i use the format cell activity it is showing some other error

8

@Gokul_Murali

You can try Read and Write also using Excel activities

Regards,

9

Hi @Gokul_Murali ,

Good Morning, Please follow the below steps after reading the excel data.

  1. Clone the Input Datatable
  2. Create a new column
  3. Loop through input Data table
  4. Add New Row and Populate data accordingly and for the new column have the excel formula=TEXT(ActualDateValue,"MM/DD/YY")
  5. Use the cloned table to write the data back to different excel table.

Regards,
Ranjith Udayakumar

10

@Gokul_Murali

Better try to use a copy paste range activity

Cheers

11

Convert or format data in your DataTable before using Write Range.

For Each row In yourDataTable.Rows
row(“DateColumn”) = Convert.ToDateTime(row(“DateColumn”)).ToString(“MM/dd/yyyy”)
Next