Can result output to a specific cell instead of range?

[Desyung12]

Hi everyone,

In my result excel sheet, I have different numbers in different cells and would like to output to a specific cell in another excel template for particular cell in my result excel sheet. Is that doable please?

For example, output cell B3 in the result excel sheet “result” to cell D3 in the excel template “template”, output cell E5 in the result excel sheet “result” to cell C4 in the excel template “template” etc…..

Thanks!

[OTrieger]

@Desyung12 

Yes, you can do it with Blob Tool, Input the template and then write it out and then save data into the specific fields, by defining the range of the data.

[caltang]

An alternative is to match dimensions to pre defined cells via a mapping table. I find it easier to manage and more dynamic. 

Though processing will be slower if it keeps writing to a specific few cells for each row of data you have, so there’s a trade off to that method.

[Desyung12]

Sorry can you pls show some sample workflows?