For Example : I want to put number 124 from an table created into an excel sheet 2 cell B5 How can I do so

Hi, yes the write to template node should work for this use-case. Just set the column and row offset to the specific cell. [image] takbb: which I was able to make write to a specific starting cell, but I don’t know the status of this component, nor whether it could assist with your use case. The node is more or less finished. The only restriction the node currently has is that it does not support very large excels. Currently with a file size above ~5-10 MB it starts to consume massive amounts of ram (as there is no streaming there yet) If there are any problems with the node - feel free to give me a note :slight_smile:

How can I input data in an particular cell of excel sheet say Sheet 2 Cell : B5

KNIME Extensions

mlauber71 April 11, 2021, 1:12pm 2

@Paras welcome to the KNIME forum

This is only possible with the help of eg Python packages like openpyxl:

3 Likes