Write in a column, without generating new sheet in excel

well first read the excel data, through , then I specify the data to use through , I store it in a list and through the in a page I generate codes by In the middle of my list previously extracted, then I extract those codes by means of , and finally I want to write it in the initial excel, but if I use , write them at the end of the document and not in parallel with the data, could someone help me?
Pruebas.zip (71.7 KB)

help
@Dave
@ppr

@borismh
What does do
write range with Range Info P1 and appropriate addheader settings?

@ppr
Yes, but when I do that, I overwrite the entire table in the comments column, and do not write the values that I want, since there is no space to write my extracted value, only the location of the Excel, the sheets, range and the datatable and I have to register values in string

@ppr

@borismh
I do See in the Screenshots but you were using a Datatable with the Data from column A Till O.

Here its Better to write selective a Datatable only with the p col Info.

Coming Back to your Options. Let US clear following. The Data you want to selective Update in col P are available as which dataype?

@ppr
I did not understand the first part very well, but the data that I will write in column p are data type , which are generated on a web page, through the I generate that data and I want to register it in the excel as I mentioned

@ppr


Now it worked but, I need the range to be dynamic and go down while writing the data, but I don’t know how to do it, any ideas?

@borismh
First of all WE will get IT Run

Your description on how you will get the p col Data and is IT on a list, Datatable … Is Not clear to me.

But i assumed That you have read in col a to o into a Datatable, right?

So my First Statement were about using Not the Datatable with col Data a to o plus p, but only column p Data and write Ränge with Range P1

So can you please Help me on how do Store col p Data? Thanks

1 Like

neglect already I left, use the variable <count = 1> and then <count = count + 1> and the range became dynamic

Thanks for the help

@borismh
Looking at your Statement i do interpretate that you are writing in a for each loop for each row the p column with a write cell Activity.

When i do Understand your question right, you were asking in how to dynamize the Range Info Like P1, p2…

Use the Index Output from for each and with a correction of plus one you can build the dynamic Ränge info

The benefit is that you dont have to handle the incremented counter manually

1 Like

@borismh
Perfect and Well done. Happy automation :grin:

2 Likes

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