How to change Excel's cell format to Custom?

[Rahul_J]

Hi Team,

How can I change the format of Excel cell/whole column using UiPath Studio ?

I need to make the column’s format to custom: _( #,##0_);_( (#,##0);(* “-”??);(@)**

Please note: Using 3rd party package is not allowed.

Regards,
Rahul

[THIRU_NANI (NaNi)]

Hi!

Could you please explain a bit more?

If possible please provide the input format and also expected format in Excel

Regards,
NaNi

[Rahul_J]

@THIRU_NANI Thanks for responding.

I am getting one input file (client file) as an excel where I need to perform VLOOKUP formula in cell (using studio) , but the format of the cell should be custom ( _( #,##0_);_( (#,##0);( “-”??* );(@ )).

By default it is coming as General

[jack.chan]

1. save below code to text file e.g. vba.txt
2. in excel application scope, call invoke VBA
   set function name = ChangeColumnFormat
   entry method parameters= {sheet name, column letter to change format}
   e.g. {"Sheet1", "B"}
   
   

Function ChangeColumnFormat(sheetName As String, columnLetter As String)
    ActiveWorkbook.Sheets(sheetName).Activate
    Columns(columnLetter & ":" & columnLetter).Select
    Selection.NumberFormat = "_( #,##0_);_( (#,##0);(* ¡°-¡±??);(@)"
    ActiveWorkbook.Save
End Function

[Rahul_J]

It’s working. Thanks for the solution @jack.chan