Hello guys i have an excel with date format column
When i read and write it to other excel excel format changed like below,
- I have used workbook activity for both read and write.
- i used preserve format in the read range property also
is there any other solution for this.
lrtetala
(Lakshman Reddy)
2
Hi @Gokul_Murali
Can you try with Format cells activity
Regards,
singh_sumit
(Sumit Singh Tariyal)
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
cheers Happy Automation
lrtetala
(Lakshman Reddy)
6
@Gokul_Murali
can you try with excel activities, if possible share your sample excel
Regards,
This excel contain like 50000 data when i use the format cell activity it is showing some other error
lrtetala
(Lakshman Reddy)
8
@Gokul_Murali
You can try Read and Write also using Excel activities
Regards,
Hi @Gokul_Murali ,
Good Morning, Please follow the below steps after reading the excel data.
- Clone the Input Datatable
- Create a new column
- Loop through input Data table
- Add New Row and Populate data accordingly and for the new column have the excel formula=TEXT(ActualDateValue,"MM/DD/YY")
- Use the cloned table to write the data back to different excel table.
Regards,
Ranjith Udayakumar
Anil_G
(Anil Gorthi)
10
@Gokul_Murali
Better try to use a copy paste range activity
Cheers
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
