Add gridlines etc to cells in Excel

[ali.koundi1 (Ali Koundi)]

Hi ,

For first point check :

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

Delete cell in excel with specific value

Yah that’s possible —use excel application scope and pass the file path of excel as input —inside the scope use READ RANGe Activity and get the output with a variable of type datatable named dt —now use a for each row loop and pass the above variable dt as input —inside the loop use IF Condition like this row(“yourcolumnname”).ToString.Equals(“0”) If it’s true it will go to THEN apart where we can use a simple assign activity like this row(“yourcolumnname”) = String.Empty Cheers @Manikan…

Delete empty rows in excel

@Aregala_Yedukondalu , If that is the case, then we can perform a Clear Data operation using Write Cell Activity first on the Sheet, then you can use Write Range Activity on the Same sheet. If you have access to Modern Excel Activities, then you could try with the below Approach as well using Clear Sheet/Range/Table Activity. [image] If modern activities are not preferred, then you could check with the below post on using Write Cell Activity to Clear the Sheet.

I hope be useful,
Regards.