Need To set Borders in excel report using uipath studio?

[SND0912 (Shiva0912)]

Sample Input:

output report:

[mkankatala (Mahesh Kankatala)]

Hi @SND0912

Below thread may help you,

How to add border for excel range in sheet

Hi, Can you try the following sample using ClosedXML? Sample20230930-1aL_Windows.zip (11.6 KB) Using wb As New ClosedXML.Excel.XLWorkbook(filename) Dim sheet As ClosedXML.Excel.IXLWorksheet = wb.Worksheet(sheetName) With sheet.Range(strRange).Style .Border.SetTopBorder(CLosedXML.Excel.XLBorderStyleValues.Thin) .Border.SetBottomBorder(CLosedXML.Excel.XLBorderStyleValues.Thin) .Border.SetLeftBorder(CLosedXML.Excel.XLBorderSt…

Hope it helps!!

[Krishna_Raj]

@SND0912

How to give border by using uipath dynamically

Hi @anjani_priya [image] Input (1).txt (539 Bytes) After running the process below is the output. Book 1 (1).xlsx (13.1 KB) Regards

check this reference

[jack.chan]

@SND0912
try this
siva.xaml (8.4 KB)
vba.txt (1.8 KB)

[pradeep931 (Pradeep Bandharam)]

Hi @SND0912

You can find the marketplace package named “Balareva EasyExcel Activities,” which includes a direct activity for applying borders to cell ranges.