Knime Crash Course: The KNIME Forum

[@bytesandbudgets]

Watch the video about the KNIME hub here: kzbin.info/www/bejne/qpy0fHeqerCjbqc

[@gordonfood258]

How to format a certain column to "Align left" format?

[@bytesandbudgets]

That's basically something you need to do either through the new Excel Cell Updater Node (new node since KNIME version 4.5) and using a preformatted Excel template file or by using the XLS formatter nodes from the Continental Nodes extension. Anyways, these kinds of formats are applied to Excel files but not to KNIME tables. Hope this helps, let me know, if I should do a video about it

[@gordonfood258]

@@bytesandbudgets Thanks for your response mate! I've tried the XLS formatter nodes and it has XLS cell formatter which is specific for a CELL only not 'COLUMN'. In my project, one step needed is to 'Align left' all data in column A to F. Is it possible or do we another way to do this? Appreciate your help on this as I've been trying to find out a solution for this for a long time now. :S

[@bytesandbudgets]

@@gordonfood258 You can basically assign more than one tag in the Rule Engine of the XLS Formatter nodes. You tag them "left-align" and then format that specific tag further down the line. Give me a few mins and I'll do a quick video.

[@gordonfood258]

@@bytesandbudgets Is this real? If yes, THANK YOU SO MUCH!!! Will wait for your video and my long time problem hope to be resolved soon. :)

[@bytesandbudgets]

Hey Gordon... here's the video: kzbin.info/www/bejne/eni9p2aDa9qbr9E I only align 3 columns with 1 format, but I guess you get the point. Let me know, if you have any questions. I am also happy to create quick series on the XLS Formatter nodes themselves (or in general about Excel formatting automation through KNIME)