Update format of Datatable without using for each

[ZARA_Clark_Vincent_M]

Hello me trying to update format of values in the column of a datatable. particularly change date from dd/MMMM/yy to MMM/yyyy. appreciate if someone can help me this through assign activity (linq). Thanks

[aanandsanraj (Anandraj Rajendran)]

Hi @ZARA_Clark_Vincent_M,

Check this link

Datatable column update using Foreach in lambda expression is throwing an error

Hi @ppr, Thank you so much for your help. And sorry about the delayed post. Your xaml was working fine when I ran it individually but it was not working when i formed the datatable from excel source. Not sure why, but only the below code seems to working for me - DataTable.AsEnumerable().ToList().ForEach(Sub (r) r.SetField(Of String)(“Start time”, Date.Parse(r.Item(“Start time”).ToString(), CultureInfo.InvariantCulture).ToString(“M/d/yyyy”))) I don’t think I would have been able to fix this …

[ZARA_Clark_Vincent_M]

thank you…reading the link it seems that it still uses for each

[Manish540 (Manish Shettigar)]

Can you send a sample excel file?? @ZARA_Clark_Vincent_M

[ZARA_Clark_Vincent_M]

Hi @Manish540
just a simple table, containing a column date, to change the format from mm/DD/yyyy to MMM yyyy

[Pratik_Wavhal]

Hi @ZARA_Clark_Vincent_M

Have a look to the below thread :-

How to write excel column value as Integer?

Hi @kishore.shetty, To change cell format that you can use this activity below attached. Here is the video. [UiPath | How to change the cell or column format in Excel | Guide (datatype)] Regards Balamurugan.S

Mark as solution and like it if this helps you

Happy Automation

Best Regards
Er Pratik Wavhal

[Matt_S]

Try using BalaReva.Excel.Activities Change Cell Type, for the cell use “B:B” for whole column. This works without calling an excel scope activity. This package has awesome excel activities that do not need the scope activity.

[Matt_S]

sorry this is for excel files only (I was reading another post)

[ZARA_Clark_Vincent_M]

Thank you for all the responses, i agree that using balareva excel activities will definitely do the trick. However, i am more on learning and understanding the using linq. Hence, i am quite confused on when can i use …Select (Function(x) Convert.todate(x(“Columnname”)).ToString(“MMM/yyyy”)) and end it to a CopytoDatatable