Changing Column In Excel

[bagayoko.isaac.b]

I am trying to get my bot to read a particular column on my excel sheet named “Termination Date”. This column currently displays the date and the time, I want to reformat this column to display just the date. I am currently getting an error saying “Termination Date” does not belong to the datatable. Can someone please advise?

[Arpit_Kesharwani]

@bagayoko.isaac.b Your expression to get column value is incorrect. It should be row.Item(“Termination Date”)

[Latika10011740 (Latika V N Durga Bhavani)]

Hi @bagayoko.isaac.b

I have change Datetime column value to Date only.

Please find the attached workflow for your reference.

Thanks
LatikaColumnChange.zip (22.9 KB)

[balupad14 (Balamurugan)]

Hi @bagayoko.isaac.b

Check this one to change the column format in excel.

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

[bagayoko.isaac.b]

Hello, Thank yo for your suggestion. Now I keep getting the error that “Column F does not belong to table DataTable”. Do you know how I can fix this?

[Arpit_Kesharwani]

@bagayoko.isaac.b Could you check column name in datatable by setting a breakpoint in debug mode.