Dear all, I have created a workflow reading two excel files with the excel reader node, filtering a sheet and writing it back using excel writer: [image] So far - so good :slight_smile: The end result written back using excel writer should have the following properties: header in row1 should be frozen header in row1 should have grey background all cells should have auto-size and auto-high auto filter should be set Write result into excel sheet I tried to realize this using xls formatter from Continental, but run into problems. I can’t connect excelwriter to xlsformatter node. Watching the youtube video does not helped me. I assume I have to unpivot my source into xls control table but there i am stuck. Does anybody has an idea? Thx for help! BR, Heinz

@Heinz I work heavily between KNIME and Excel and I find this node to be infinitely easier if you are proficient on the Excel side. [image] Write To Excel Template This node writes the input data table into an existing Excel file without changing its formatting. Alternatively a new file will be created based on the templa… The Continental nodes are fine if you just want a few simple formatting rules applied to clean up a table, but if you really want to dial in a nice presentation it will cost you hours. I can do the same thing with the write to a template approach in a few minutes as well as include conditional formatting, user interaction settings, graphs, etc. You can also write around existing formulas (using blank cells on the KNIME side) to update data only where necessary keeping interactivity in tact.

How to work with XLS Formatter

KNIME Analytics Platform

takbb July 31, 2023, 10:36am 2

Hi @Heinz , would you be able to upload your workflow with some sample spreadsheets (after replacing any sensitive data with dummy data). I have a couple of components that may be able to speed you up with using the continental nodes, and happy to try to give some pointers.

See also this forum article I wrote last year…

along with this demo worflow

And

and (a bit more involved, and a few additional components )

1 Like