Guys, I want to write the datatable values to the workbook starting from a specific cell.For example, I want to write the datatable values starting from below the cell which has the value “Variance”.I couldn’t define a specific cell location because the columns are dynamic as the automation goes by.Help me please.
You can use find/replace cell activity
Which is a modern excel activity gives you the cell location as output
Below that use write range activity and in the range pass the output variable
Hi @chilled_lad ,
Could you give sample
I think we can find index to start then write with dynamic
eg : index
You will need to find where this value is at the workbook (there are many ways to do that, like reading the file manually and seeking for the index or simply using find/replace activity)
Then you can use write range and put the starting cell you get from the previous step
@Shiva_Nikhil I’ll try that, Thank you.
@Nguyen_Van_Luong1 I already figured it out, Thank you bro!
@Michael.Vornes Thanks for your information. I’ve already figured it out.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.