Skip Excel row (or cell?) if empty

Help Studio
, ,
1

Hi! Tried a few solutions online, but nothing worked so I’m making this post.

I got an Excel file as an input. Using For Each Row only for A1:A6 (has header named “Subjects”) I’m trying to basically only read a max. of 5 book subjects and search each one of them online, then I extract info about them into another Excel. Everything works, but I also want to skip any empty cell on that column if need be. All of this is inside an Excel Process Scope. I tried using an If with String.IsNullOrEmpty(CurrentRow(“Subjects”).ToString) Then the Continue activity, Else does everything I asked for, but the process just stops if it detects an empty cell in the middle of the A1:A6 range. What can I do? Thank you!

2

@Wolf214356,

Can you please share the excel file you are using to see how it looks like.

3

Issue might be with how the Continue activity is placed. Can u share the screenshot?

4

Hie @Wolf214356 can you try this
your input as an excel data

An Excel spreadsheet is displayed with a column labeled "Subject" containing the entries "Skip1", "Skip2", "skip3", "skip5", and "skip7". (Captioned by AI)
An Excel spreadsheet is displayed with a column labeled "Subject" containing the entries "Skip1", "Skip2", "skip3", "skip5", and "skip7". (Captioned by AI)729×353 3.95 KB

steps

The image depicts a UiPath workflow for reading data from an Excel sheet and writing non-empty "Subject" column values to the output. (Captioned by AI)
The image depicts a UiPath workflow for reading data from an Excel sheet and writing non-empty "Subject" column values to the output. (Captioned by AI)706×473 20.2 KB

The image shows a UiPath workflow sequence that iterates through each row of a data table and writes the "Subject" column value to a line if it is not empty. (Captioned by AI)
The image shows a UiPath workflow sequence that iterates through each row of a data table and writes the "Subject" column value to a line if it is not empty. (Captioned by AI)618×505 19.5 KB

your output

The image shows a debugging log with icons and a list detailing the start, execution, and completion times for a process involving skipped empty cells. (Captioned by AI)
The image shows a debugging log with icons and a list detailing the start, execution, and completion times for a process involving skipped empty cells. (Captioned by AI)503×236 6.15 KB

cheers

5

I don’t see any Excel Application Scope in my Studio when trying to do this. I’m using an Excel Process Scope in my project and I tried using “Write line”, but I can’t use Row since it says it’s not declared. I used CurrentRow instead and it only reads the values up to the blank cell when it completely stops doing anything. I’d prefer something that works with the Excel Process Scope since I’m not going to redo the whole project just for this to work, there must be a solution for my case as well. Here’s a part of my project (ignore the fact that it’s “Subiecte” and not “Subjects”, that’s how it’s actually meant to be).

Ifissue
Ifissue728×866 29.4 KB

6

Here’s a part of my project (ignore the fact that it’s “Subiecte” and not “Subjects”, that’s how it’s actually meant to be).

Ifissue
Ifissue728×866 29.4 KB

7

@Wolf214356 the issue you get in the read cell and if you want to take the value simply use 1 assign activity of string variable eq- strCellValue = currentrow(“yourcolumn”).tostring
so it will store all the value inside the each cell except the blank one

8

Hi @Wolf214356

In activities panel, go in filters and check the classic panel, so that you can use excel application scope activities.

Thanks!!

9

Give you the coe @Wolf214356 run it and check it
Skip Empty Cell.zip (238.3 KB)

and also attaching screenshot
create a integer variable in the for each property so bot will go and increament the row data

This image shows a segment of an automated workflow using a "For Each Row in Data Table" activity to iterate through rows in a Data Table (dt1), with a condition checking if the "Subject" field is empty, highlighted components, and an indexed variable (currentIndex). (Captioned by AI)
This image shows a segment of an automated workflow using a "For Each Row in Data Table" activity to iterate through rows in a Data Table (dt1), with a condition checking if the "Subject" field is empty, highlighted components, and an indexed variable (currentIndex). (Captioned by AI)976×337 15.7 KB

and inside the read cell pass this

The image shows an Excel automation script that reads the value from a dynamically determined cell in column "A" of "Sheet1", with the specific cell being "A" followed by the value of (currentIndex + 2). (Captioned by AI)
The image shows an Excel automation script that reads the value from a dynamically determined cell in column "A" of "Sheet1", with the specific cell being "A" followed by the value of (currentIndex + 2). (Captioned by AI)909×224 16.6 KB

cheers

10

It works with your code, but not with mine. I’m using For Each Excel Row in my project, not For Each Row in Data Table. Is that the issue, should I change it? Or how to make it work with For Each Excel Row? I’d prefer to keep this activity if possible.

11

@Wolf214356 jus changed it with fo each row activity as i attached in the code.it will resolve the query. and it not affect at all your code because you have to tackle with the increament row value also like first it will go to row2 ,3,4 so on .thats why i suggest to go with for each row activity

cheers

12

I solved this. Just had to check the Empty Row Behavior to “Skip” in the Properties Pannel of the For Each Excel Row.
It also works with if, but then you have to check “Process” in Empty Row Behavior.

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.