How to delete rows from an excel file

Help
, ,
1

Good afternoon, I have a spreadsheet where I want to delete rows that includes a specific word, but can this be done without a data table?

thank you.

2

Hi @markostripe
Welcome to the community forum!

This can be accomplished with the ‘Insert/Delete Rows’ activity within an Excel Application Scope. Using an if statement that tests if your specific word is in the row.

Hope this helps.

3

should the if condition contain the word I’m looking for? Sorry but I’m not an expert here and I got stuck in this process.

thank you.

4

Could you try this:

%nameOfWorkbookFromExcelScope%.GetSelectedRange().Contains(%stringYoureLookingFor%)
5

image

this is how it looks my Excel application scope, not sure how to add what you tell me.

6

Capture
Capture1565×669 34.1 KB

7

not sure what I’m doing wrong, it is giving me an error, here is a screenshot

image
image788×311 8.64 KB

8

Could you hover over and show what the error is?

9

image
image780×307 55.3 KB

10

What versions of Studio and UiPath.Excel.Activities do you have?

11

@markostripe there you have to use workbook activity not the excel application scope. and to achieve your requirement you can try like this use excel application scope and pass the path in it and use read range activity store it in a variable say dt1.now give if condition like dt1.rows.contains("word you’re looking for ") now if it find the word in a row it will go to then condition there you can give whether you can want to delete or anything

13

Hi @kissbiss
Welcome to the community forum!

Was there more that you meant to add to this comment?

14

im a pentester approved by uipath program at hackerone and im doing my job

15

2017 1.6435 is what it says.

16

Hello, I am totally confused here, here is what I have, and it says that rows is not part of string, sorry but I’m a beginer on this, hope you can help.

image