I want to delete blank column data and entire data in from empty row . so the empty row will get deleted

[S_Bot (SS)]

I want to delete blank column data and entire data in from empty row

[Krishna_Raj]

Delete Blank Column Data:

1. Read Range Activity:
   Use the “Read Range” activity to read your Excel or DataTable into a variable.
2. Remove Empty Columns Activity:
   Add the “Remove Empty Columns” activity.
   Input the DataTable variable from the previous step into the “Input” property.
   This activity will remove any columns in the DataTable that are entirely blank.
3. Write Range Activity:
   Use the “Write Range” activity to write the modified DataTable back to Excel or wherever you need.

[AJ_Ask]

Hi @S_Bot

First you get the datatable by reading the excel. Afterwards, you can delete the empty lines with the filter activity and later write the datatable to excel.

Hope this helps

[Shiva_Nikhil]

@S_Bot

dt1.AsEnumerable.Where(Function(a) not a.ItemArray.any(Function(r) r.ToString="")).CopyToDataTable

[ppr (Peter Preuss)]

@Krishna_Raj

Remove Empty Columns

May we ask for a screenshot of this activity? Thanks for Support

[rohit.mane]

Hello,

Below are the some excel steps those we need to implement in UiPath:

• Select your data from the 1st to the last cell.
• Press F5 to bring the Go to dialog.
• In the dialog box click on Special button.
• In the Go to special dialog, choose “Blanks” radio button and click OK.
• Right-click on any selected cell and select “Delete…”.
• In the “Delete” dialog box, choose “Entire row” and click Entire row.

I hope this will help you implement the code.