Remove Value based on columns Name

[Shyam_Pragash]

Hi,

i have a Excel Data in that sheet having many columns is there. so that i want to remove value on Selective column Name.

Input Data:

Expected Output

Thanks
Shyam

[nikhil.girish]

Hi @Shyam_Pragash
If you want to directly remove columns of the sheet, can you try Insert/Remove columns activity?

if you want to delete columns by name
kindly refer this link

How to delete columns by name in Excel?

@Tana20 - Here you go… xaml image : [image] Input: [image] Output: [image] You can see the first column is deleted. You need below packages for these… [image] however in this case I need to delete columns in different positions… You can delete any columns by range or specifically [image] . Don’t forgot to add quotes. Please mark this as solution, if it solves your query.

Thanks

[arivu96 (Arivazhagan A)]

Hi @Shyam_Pragash,
You can delete a column and recreate the same column, so all the value are empty.
Else
use for each row activity loop it
using Assign Activity
row("Col2")=string.empty

Regards,
Arivu

[jack.chan]

use invoke code activity with this

dt.AsEnumerable().ToList().ForEach(Sub(row) row("Col2")="")
dt.AsEnumerable().ToList().ForEach(Sub(row) row("Col4")="")

invoke code arguments:

use this for reference
TestA.xaml (8.7 KB)

[jack.chan]

@Shyam_Pragash
if you want to make it dynamic, you can add 1 more variable “columnsToEmpty” then split by comma to an array and iterate over this array

TestA.xaml (10.0 KB)

[Shyam_Pragash]

Hi @jack.chan @arivu96 @nikhil.girish

Thanks you alll…

i got the soluation.

Thanks
Shyam

[supermanPunch (Arpan)]

Hi @Shyam_Pragash ,

Maybe this is an Alternate Solution, where we deal with only the Columns, instead of Updating the all row values of that Column :

1. We would first have to Get all the Column Names from the Datatable as an Array of String. This would be used later for Ordering of the Columns.

columnNamesArray = DT.Columns.Cast(Of DataColumn).Select(Function(x)x.ColumnName.ToString.Trim).ToArray

2. Next, we create a Array of String, which contains the Columns that need to be Removed using an Assign Activity

columnsToRemoveValues = {"Quotation Ref"}

3. Then, we Remove the Columns specified in columnsToRemoveValues from the DT and we add them again and Order the Columns using Assign Activity. The Ordering is as of the Original DT Columns.
   

   

4. Next, we write the Datatable back to the Excel Sheet using Write Range Activity.

Find the Example workflow Below :
Delete_ColumnValues.zip (10.3 KB)