We can add a new column to the excel spreadsheet, is it possible to define the format as say "mm/dd/yyyy' and text aligned to right?

[Lipika_Porey]

Hi @Geetha,

You can use invoke code activity for excel formatting in “mm/dd/yyyy” and write code in below format. This works

Refer the below steps mentioned in the post to eliminate unexpected error while using Microsoft.Office.Interop.Excel

HOWTO: Use MS Office COM interop with UiPath

HOWTO: Use MS Office COM interop with UiPath This tutorial is a step-by-step guide on how to use MS Office COM interop with UiPath. There are many questions on the forums on how to use the Microsoft Office COM interop with UiPath. People were looking for ways to use the Invoke Code activity along with the Microsoft.Office.Interop.Excel or Microsoft.Office.Interop.Outlook assemblies. Some people have been able to get it to work, but others have not been able to get it to work even when followin…

However, I personally feel that @Palaniyappan suggestion to change the input value of the column is better.

References that will help-

Formatting a Range of Cells In Excel VBA - Excel Macros

XlHAlign Enumeration (Microsoft.Office.Interop.Excel)