Delete row in an Excel File witha

Help
1

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
2

Hi
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
Or
— 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
3

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

1 Like
4

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

2 Likes
5

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

6

aaha
sorry for that
thanks for your kindness
Cheers @hsendel

1 Like
7

any issues to be discussed @CamiCat
everything good
Cheers