Center cells in Excel with vb.net

[Maria_Ines_Almeida (Maria Inês Almeida)]

Hello.

How can I center the cells in an excel file with vb.net?

Thanks

[sangeethaneelavannan1 (Sangeetha Neelavannan)]

@Maria_Ines_Almeida

How can I center the cells in an excel file with vb.net?

Hi @Maria_Ines_Almeida
Check this out

UiPath - Set Cell Color, Alignment, Font Style | Format Cell Activity |UiPath Tutorial

[Maria_Ines_Almeida (Maria Inês Almeida)]

Thank you very much for your answer but those activities are for Studio X and I need a solution for Studio

[jack.chan]

1. place this vba file in your project folder
   vba.txt (252 Bytes)

2. in uipath, excel application scope, call invoke vba

codefilepath = “vba.txt”
entryMethodName = “centerText”
EntryMethodParam = {"Sheet1", "B"} (you can change it to your own sheet/column letter)