Write cell in excel if row contains course name and specific date

Help
1

Hello,

How do I loop through a excel sheet and write cell if that rows contain the course name and date i want and skip/go to the next row if it does not fulfill my requirements.
Been trying for each loop and putting if else in the for each but its not working.

Thank you :slight_smile:

2 Likes
2

Hi @Magpie444

Welcome to the community!!

I suppose you know the column where you want to write in the cell.

So, let’s follow the below steps.

  • Have a int variable and assign it to 1 - this will be used within the loop to increment in each iteration to figure out the excel row we want to write in.
  • Use Read Range to read the excel to a datatable
  • use a for each row loop to loop through the data table.
  • within the loop, have a if condition to check whether it has the course name and date

Row("ColumnName").ToString.Contains(Course name variable)
Or
Use this if its empty when course name is not available
String.IsNullOrEmpty(row("ColumnName").ToString)

Same goes with the date

  • now in the if condition, place the write cell activity to write the value in the desired cell.
    Use the integer variable we declared to find the row. So in write cell, for the cell number configure it as follows
    “D” + rowNumberVariable.ToString
  • now outside the if condition, but inside the loop, place an assign activity and increment the row number variable by 1

This will work for you :slight_smile:

4 Likes
3

Hi thanks for your help :slight_smile: i have tried what u told me to do but its still not working it doesnt seem to be picking up the row. And the rowNumberVariable is not increment.

image
image1015×748 19.3 KB

1 Like
4

@Magpie444

You specified condition like this:
writeRow(“1”)

Here 1 is the Column name or Column Index ?

If it is Column Index then it should be like this:

writeRow(1).ToString

2 Likes
5

@Magpie444

Along with the concern of @lakshman I also would like to see what you have in your Cell property of the write cell activity

2 Likes
6

hi,
1 is the column name

1 Like
7

@Magpie444

Before IF condition, print this value using message box and check once.

writeRow(“1”).ToString

8

image

9

Hi it is running through all the rows from that column

10

Hi,
I solved my issue the continue activity was causing the problem.

11

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