Delete row in an Excel File witha

Hello friends,
@rkelchuri, @Ninett_Panfir, @Rammohan91, @balupad14, @Florent_Salendres, @vvaidya, @Palaniyappan, @ClaytonM

I have a spreadsheet in an Excel file where I want to delete rows which have columns populated in a certain way, but can this be done without a data table?
Can youplease share a sample workflow?
Thank you so much,
Cami :):smiley:

1 Like

Yes of course we can remove set of rows without datatable
โ€”Itโ€™s possible either with VBA script
But itโ€™s not that robust and bit complicated
โ€”Or still we got another option like
Insert/Delete rows activity

With which we can delete
โ€” even to be better to go for using datatable
Which has many simple ways that include
โ€” Filter datatable activity
โ€”remove datarows
โ€” DefaultView menthods

Fine kindly refer for example on deleting rows of excel without datatable

Hope this would help you
Cheers @CamiCat

1 Like

Thank you @Palaniyappan.
How is it possible to filter the rows to delete?
Not by indexes?
Thank you,

1 Like

yes of course
in filter datatable activity along with filter wizard
we got two radio button options
with remove we can filter the one we dont need
Cheers @CamiCat


You Replied on different topic than mine is : Remove rows Containing a Keyword A3.
Anyway Thanks for Your Prompt Responses.

sorry for that
thanks for your kindness
Cheers @hsendel

1 Like

any issues to be discussed @CamiCat
everything good