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)
@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
@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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE