Writing to a specific excel column

Help Activities
, , ,
1

Hey,

I’ve been trying to get the bot to write a value into into a specific column (C) of an excel spreadsheet. In short:

The bot is working from an excel list and reading from column B, it uses this value to search a portal and scrape another value which I want to add to C.

I don’t know why, but I’m struggling to do this, I feel like it should be so simple; what am I doing wrong?

2

@dr1992

Use Write cell activity

3

Well yeah, but it isn’t iterating down the spreadsheet.

4

Hi @dr1992 ,
You can use write range activity
image
with cell index you want
Regards,
LNV

5

Hi @dr1992 ,
If you want to WF for detail, you can share your file to me in message, I will test in my workflow for you
Regards,
LNV

6

@dr1992

For Each row In dataTable.Rows
valueFromColumnB = row(“Column B”).ToString() // Replace with actual column name
// Perform portal scraping to get additionalValue

// Write the additionalValue to column C in the same row
cellReference = "C" + (dataTable.Rows.IndexOf(row) + 2).ToString() // Add 2 to convert index to Excel row number
Write Cell (Cell = cellReference, Value = additionalValue)

End For

7

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