How to write variable value in next available cell in an excel column?

Help
,
42

Hi.

You can probably use the .Skip() in the For each
Like:

ForEach item in ChildOutput.Skip(1)

The above will just skip the first item.

You can also just place in an If activity so it skips any “aaname” that equals “Select”
For example:

Get Attribute "aaname"
If activity: invalidList.Trim.ToUpper <> "SELECT"
    Add Data Row

That will skip anything that equals Select

Regard.

1 Like
43

Thanks @ClaytonM it worked :slight_smile:

44

Hi,

I Have to read two file names from web page and write to excel sheet.but every time it is overwriting previous one.please,help me to solve that.

45

Hi @Srilatha,
Hope this could help you.
Have you tried to use append range activity?
https://activities.uipath.com/docs/append-range
Best Regards,
Susana

1 Like
46

Hi,

In Append range Activity,it is showing Data table .but iam using write cell after get text from web page.I dont know how to use it? sorry,iam new to UI path.Please,help me with it.

47

Hello @Srilatha,

If you know in which cells the fileNames have to be written then you can indicate the specific cell in the range field of the write cell activity.

  • Range - The Excel cell or range that you want to write to. If a value already exists at the specified coordinates, it is overwritten. Only string variables and strings are supported.

image

Other possible solution could be built a dataTable and insert all the fileNames you have to write in the excel file. Then you only need to use a write range activity to fill the file.test_10585.xlsx (7.6 KB)

Do you know UiPath Academy? It Is the best way to start with UiPath :slight_smile:

Best Regards,
Susana

1 Like
48

Thanks @Susana,You helped me a lot.

49

I have other Query.

How to compare two columns values in two different sheets in excel and update the status whether they are equal or not in first sheet.please,help me .

50

Refer the link , it will help you

Next time make sure , you create new topic for the new issue as it is not relevant to the discussion going on here in this topic category